This section is from the "Practical PostgreSQL" book, by John Worsley and Joshua Drake. Also available from Amazon: Practical PostgreSQL.
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.
 
Continue to: