Re: Connecting PHP-based Application to Postgres-9.0.3

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