Re: monitoring running queries?

On Thu, 8 Feb 2001, Brice Ruth wrote:

> Its not working ... I looked at the admin docs and edited the pg_options
> file appropriately ... the following is what appears in /var/log/messages:
>
> postgres[23686]: read_pg_options: verbose=2,query=4,syslog=2
>
> But no queries ... I sent SIG_HUP to postmaster, even restarted
> postmaster. The file /var/log/postgresql appears to be empty as well.

I don't know how you are starting postgreSQL, but I just have it redirect
everything to a log file under the postgres super user's directory:

nohup postmaster [options] >>server.log 2>&1 &

Make sure you don't use the -S option -- it detaches from the tty and you
will get no output!

-- Brett
http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Above all else -- sky.