Re: [GENERAL] postgres getting slow

At 21:51 +0300 on 20/05/1999, Brian wrote:

> What sort of things to do you catch with logging this? I haven't seen a
> single thing goto this file since starting it:
>
> export PGLOGFILE=/var/lib/pgsql/pg.log
> su postgres -c '/usr/bin/postmaster -B 250 -i -S -D/var/lib/pgsql -o -S
>1024 >> ${PGLOGFILE} 2>&1'

I usually add "-d 2" to my postmaster invocation. It puts a lot of
information in the logfile, although I must say I've never been happy about
Postgres's logs. If you want to see where an error has occured, the actual
query is buried within many internal messages.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma