Search Postgresql Archives

Re: ssl connections to postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



James B. Byrne wrote:
On Wed, July 25, 2007 03:13, Albe Laurenz wrote:
James B. Byrne wrote:
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:
[snip]

Thank you.  I infer that this setting would generate an awful lot of log
entries regarding a wide range of process actions and that your intention
is that it only be used temporarily to confirm a valid ssl configuration
works as expected.  I was actually hoping to find some way of logging the
type of connection made without having to get excessive (for my purpose)
details about other activities in unrelated ares of the server process. But, this is nonetheless valuable information. Thanks.

You could probably do something like set the default log-level high and then override it for the database/users in question (alter database set ...)

Of course, the simplest solution would be to change the code yourself. Shouldn't be more than a line or two, you just want to add one piece of information to an existing log line. That's also the simplest way to ask core to tweak the line too: I want to change line nnn in file fff to add the following...

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux