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 onthe server. PG does some pretty good logging of failed connections if youhave 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 enableappropriate logging to /var/log/messages (where syslog messages go). Pleaseadvise. Thanks, Rich