PostgreSQL has the capability to support SSL with the --with-ssl configuration option. This option is a good option if you are going to be doing the majority of your work with PostgreSQL in psql .

However, most people will choose to use PostgreSQL as a backend to a client application. As this is the case, you will either need to develop your client to understand SSL with PostgreSQL or choose a different method of encyrypting sessions between your client or application and the PostgreSQL server.