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:[EMAIL PROTECTED]) 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 [EMAIL PROTECTED](48360)
(468b5848.48e:[EMAIL PROTECTED]) DEBUG: SSL connection from "(anonymous)"
2007-07-04 10:20:24.421 CEST [EMAIL PROTECTED](48360)
(468b5848.48e:[EMAIL PROTECTED]) DEBUG: received password packet
2007-07-04 10:20:24.421 CEST [EMAIL PROTECTED](48360)
(468b5848.48e:[EMAIL PROTECTED]) LOG: connection authorized: user=erich
database=typo3
Yours,
Laurenz Albe
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
