Re: ssl connections to postgresql

James B. Byrne wrote:
>
> I have setup postgresql to use ssl and have configured and
> restarted the service without error. I am connecting a web app
> from a remote httpd host and I would like to verify that
> the connection between these two machines is indeed
> employing ssl for the application in question.

If you set log_min_messages and log_min_error_statement to debug5,
you will get something like this in your log:

2007-07-04 10:20:24.348 CEST [unknown]@ (468b5848.48e:0(at)[unknown]) LOG:
connection received: host=10.153.13.5 port=48360
2007-07-04 10:20:24.348 CEST @ (:@) DEBUG: forked new backend, pid=1166
socket=7
2007-07-04 10:20:24.420 CEST [unknown](at)10(dot)153(dot)13(dot)5(48360)
(468b5848.48e:0(at)[unknown]) DEBUG: SSL connection from "(anonymous)"
2007-07-04 10:20:24.421 CEST erich(at)10(dot)153(dot)13(dot)5(48360)
(468b5848.48e:0(at)typo3) DEBUG: received password packet
2007-07-04 10:20:24.421 CEST erich(at)10(dot)153(dot)13(dot)5(48360)
(468b5848.48e:0(at)typo3) LOG: connection authorized: user=erich
database=typo3

Yours,
Laurenz Albe