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@[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]@10.153.13.5(48360)
(468b5848.48e:0@[unknown]) DEBUG: SSL connection from "(anonymous)"
2007-07-04 10:20:24.421 CEST erich@10.153.13.5(48360)
(468b5848.48e:0@typo3) DEBUG: received password packet
2007-07-04 10:20:24.421 CEST erich@10.153.13.5(48360)
(468b5848.48e:0@typo3) LOG: connection authorized: user=erich
database=typo3
Yours,
Laurenz Albe