Connecting to an SSL enabled Postgres Server with Oracle Sql Developer

daniel —Wed, 03/04/2015 - 9:31am

First, add the Postgres driver to Oracle Sql Developer:
Tools > Preferences > Database > "Third Party JDBC Drivers" > Add Entry

Navigate to a save location of the Postgresql JDBC driver from jdbc.postgresql.org
Next, In Oracle Sql Developer, crate a new connection. Give it a Connection Name, Username, HostName, and Port. Now Save.
Exit Sql Developer
Open ~/.sqldeveloper/system4.0.3.16.84/o.jdeveloper.db.connection.12.1.3.2.41.140908.1359/connections.xml
Update the customUrl for the connection you just created to something like:
<StringRefAddr addrType="customUrl">
<Contents>jdbc:postgresql://localhost:5432/mydatabasename?ssl=true</Contents>
</StringRefAddr>

Basically, we're adding the ?ssl=true parameter to the connection string.

Navigation

daniel —Fri, 08/25/2006 - 10:16pm

In all affairs it's a healthy thing now and then to hang a question mark on the things you have long taken for granted.

—

Bertrand Russell