Postgres Pro
Downloads
Home   >   mailing lists

Re: Does PostGreSQL support SSL inbuilt? - Mailing list pgsql-general

From dipti shah
Subject Re: Does PostGreSQL support SSL inbuilt?
Date
Msg-id d5b05a951002022241r49449ffco851d7f36691b0393@mail.gmail.com
Whole thread Raw
In response to Re: Does PostGreSQL support SSL inbuilt?  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
Tree view
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:
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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Questions on PostGreSQL Authentication mechanism...
Next
From: dipti shah
Date:
Subject: Re: Questions on PostGreSQL Authentication mechanism...