Re: Connecting PHP-based Application to Postgres-9.0.3

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
>