From: | Brice Ruth <brice(at)webprojkt(dot)com> |
---|---|
To: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: monitoring running queries? |
Date: | 2001-02-08 15:25:49 |
Message-ID: | 3A82BA7D.40F4FA5E@webprojkt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Cool, that worked. Thank you.
-Brice
"Brett W. McCoy" wrote:
>
> 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.
--
Brice Ruth
WebProjkt, Inc.
VP, Director of Internet Technology
http://www.webprojkt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2001-02-08 15:30:37 | Re: tuples too big |
Previous Message | Lamar Owen | 2001-02-08 15:20:17 | Re: .mips.rpm |