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