In the postgresql.conf file, look for these parameters.
log_destination (can be set to stderr, csvlog, syslog, and eventlog, you
probably want syslog).
log_connections (default is off, turn this on to see all connection
attempts to the database)
log_disconnections (same as log_connections)
These should let you see the connection information from the perspective
of the database.
- Brian F
Consistent State
On 04/07/2011 11:35 AM, Rich Shepard wrote:
> On Thu, 7 Apr 2011, Bill Moran wrote:
>
>> Check the PG server logs, and consider increasing some logging levels on
>> the server. PG does some pretty good logging of failed connections
>> if you
>> have the settings right.
>
> Bill,
>
> There was no logging. I looked at /usr/local/pgsql/data/postgresql.conf
> and had no idea what should be changed (and to what values) to enable
> appropriate logging to /var/log/messages (where syslog messages go).
> Please
> advise.
>
> Thanks,
>
> Rich
>