pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
forcing SSL 2+ messages / 2 participants [nested] [flat]
* forcing SSL @ 2004-02-14 19:13 Eric <hehe88hk@yahoo.com.hk> 0 siblings, 1 reply; 2+ messages in thread From: hehe88hk@yahoo.com.hk @ 2004-02-14 19:13 UTC (permalink / raw) To: pgsql-admin In order to ensure all user are making SSL connection to the database, in the file pg_hba.conf, I change all the first columns into "hostssl" such that there is neither "host" nor "local" left. However, when I try to use a program written in Tcl to access the database, even without the option "requiressl=1" for "pg_connect", the program can still make connection to the database. (With the option "requiressl=1" present for "pg_connect", my program can also connect the database successfully) May I know what the problem is and how to ensure incoming SSL connection? Thank you ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: forcing SSL @ 2004-02-15 05:26 Tom Lane <tgl@sss.pgh.pa.us> parent: Eric <hehe88hk@yahoo.com.hk> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-02-15 05:26 UTC (permalink / raw) To: hehe88hk@yahoo.com.hk; +Cc: pgsql-admin hehe88hk@yahoo.com.hk (Eric) writes: > In order to ensure all user are making SSL connection to the database, > in the file pg_hba.conf, I change all the first columns into "hostssl" > such that there is neither "host" nor "local" left. > However, when I try to use a program written in Tcl to access the > database, even without the option "requiressl=1" for "pg_connect", the > program can still make connection to the database. Is this a local-Unix-socket connection? We don't bother with SSL on such connections. There's no point --- the only way to eavesdrop on a local connection is to have broken into your kernel, at which point it's game over anyway. regards, tom lane PS: it also occurs to me you might have forgotten to SIGHUP the postmaster after editing pg_hba.conf... ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-02-15 05:26 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-02-14 19:13 forcing SSL Eric <hehe88hk@yahoo.com.hk> 2004-02-15 05:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox