Re: Connecting PHP-based Application to Postgres-9.0.3

[Brian Fehrle <brianf@xxxxxxxxxxxxxxxxxxx>]

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