On Thu, 7 Apr 2011, Brian Fehrle wrote:
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)
Brian,
Hmm-m-m.
log_destination = 'syslog' # Valid values are combinations of
# stderr, csvlog, syslog, and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.
log_connections = on
log_disconnections = on
Yet, there's noting in /var/log/messages after restarting postgres.
Apr 7 11:13:14 salmo postgres[6652]: [1-1] LOG: database system is ready
to accept connections
Apr 7 11:13:14 salmo postgres[6656]: [1-1] LOG: autovacuum launcher
started
Rich
