Re: Does PostGreSQL support SSL inbuilt?

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(at)selestial(dot)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
>