----- Original Message -----
From: "Don Baccus" <[email protected]>
> Enable PG logging and examine those logs, as well.
I've taken a break to play with some PG logging on my development machine
before doing the same on production -- getting some better instrumentation
will be like turning on the light in a dark room, I hope. The only logging
I had been doing was in the AOLServer error log, where I can see all the SQL
commands as they execute.
Am I on the right track with the following? (I'm running RedHat 7.3 and
PostgreSQL 7.1)
To turn on logging, I've converted the launching command in
/etc/init.d/postgresql from
/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start > /dev/null
2>&1
to
/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start -l pg-logfile
2>&1
and then added these to postgresql.conf:
log_connections = on
log_pid = on
log_timestamp = on
debug_level = 2 (I've played with 0, 1 and 2 so far)
Any other approaches that I should look into? Any advice on settings that
will be most informative?
Thanks!
Dave
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]>
with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject:
field of your email blank.
