Re: Connecting PHP-based Application to Postgres-9.0.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.


  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



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux