Add support for connecting to Postgres with a certificate.

[dalemccrory]

Here is what is an example from Beekeeper studio:

We are looking at requiring a certificate for logging into our data warehouse.
Thanks!

[eirikbakke]

Thank you for this suggestion! Looks like Ultorg's connection dialog will require some extra bells and whistles to help configure different kinds authentication.

Meanwhile it should be possible to connect via SSL from Ultorg by adding the following "Connect Properties" in Ultorg's New Connection wizard:

• sslmode: verify-ca
• sslfactory: org.postgresql.ssl.NonValidatingFactory

And the following three properties can be omitted if the files are in their default location (see further below):

• sslrootcert: Path to root (CA) certificate file, ending .crt
• sslcert: Path to certificate file, ending .crt
• sslkey: Path to key file, ending .pk8 or pfx

(From this PostgreSQL documentation page.)

E.g. something like this:

If you put the root.crt, postgresql.crt, and postgresql.pk8 files in their default directories, shown above for Windows (substitute your own username instead of "ebakke"), or /Users/username/.postgresql/ on MacOS, then you should be able to omit the sslrootcert, sslcert, and sslkey properties. The PostgreSQL documentation suggests testing that you can log in via SSL with the standalone "psql" command first.

(Curious to hear if you can make this work; I don't have an SSL-configured server to test this with at the moment.)

[eirikbakke]

There's a new documentation site for Ultorg now, which gathers all the information about connecting to PostgreSQL (including with certificates) here:
https://www.ultorg.com/docs/connect/postgresql/

I have also opened a separate issue #79 about improving the connection UI itself to reduce the number of manual steps required to connect with a certificate.