Re: SSL

The BOFH wrote:
>
> Just installed 7.1 (first time) and enabled SSL support.  Is there a way to
> confirm that connections are being made via SSL?  The logfile shows a
> connection, but doesn't specify whether SSL was used or not.
>
> I used hostssl in the hba file.

You need to compile PostgreSQL with SSL support, and configure
pg_hba.conf appropriately.  The comments in the provided pg_hba.conf
indicate:

# ... Note that a "host"
# record will also allow SSL connections; write "hostssl" if you want to
# accept *only* SSL-secured connections from this host or hosts.

If you wanted to be really sure, you could do some packet sniffing...

--
Ron Peterson
Network & Systems Manager
Mount Holyoke College
GPG and other info at http://www.mtholyoke.edu/~rpeterso