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 <howardn...@selestial.com>wrote: > 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 >
