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.
- Log in to post comments