PostgreSQL provides the option to compile with support for SSL with the
- -with-ssl
configuration parameter. This option is a good choice if you are going to be doing the majority of your work with PostgreSQL in
psql
, as it natively supports this method of connection.
Most people choose to use PostgreSQL as a backend to a variety of client applications. If this is the
case, you will either need to develop your own client to understand SSL connections to PostgreSQL, or choose an external
method of encrypting sessions between your client or application and the PostgreSQL server (such as with SSH, or Stunnel).
