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 —Mon, 02/26/2007 - 12:29pm

There is no expedient to which a man will not go to avoid the labor of thinking.

—

Thomas A. Edison