From: | Brian Fehrle <brianf(at)consistentstate(dot)com> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Connecting PHP-based Application to Postgres-9.0.3 |
Date: | 2011-04-07 17:56:02 |
Message-ID: | 4D9DFAB2.2080902@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2011-04-07 18:17:49 | Re: Connecting PHP-based Application to Postgres-9.0.3 |
Previous Message | Rich Shepard | 2011-04-07 17:52:46 | Re: Connecting PHP-based Application to Postgres-9.0.3 |