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
