Does PostGreSQL support SSL inbuilt?

dipti shah wrote:

Hi,

I am new to PostGreSQL authentication mechanism. Does PostGreSQL
support SSL? How could I make sure that psql client communicates with
PostGreSQL server securely?

Thanks,
Dipti

Yes. See http://www.postgresql.org/docs/8.4/static/ssl-tcp.html. You can
force the server to only accept secure connections.

Howard Cole

Thanks a lot Robert and Howard. I got the information about how to set
server configuration to make SSL aware only. Please see below and let me
know if I am missing anything.

1. I need to switch on "ssl" attribute in postgresql.conf and compile the
server again.
2. In pg_hba.conf, I have to user "hostssl" method for all client
connection.

Also, after setting above configurations, if I connect to my database using
"psql -d Techdb -U postgres" then automatically it will be SSL connection or
I need to specify any option from client side?

Thanks,
Dipti

On Tue, Feb 2, 2010 at 6:13 PM, Howard Cole <howardnews@selestial.com>wrote: