Re: turning on debug without restarting postgres

From: Herbert Rabago Ambos <herbert(at)hindang(dot)msuiit(dot)edu(dot)ph>
To: Rainer Mager <rmager(at)vgkk(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: turning on debug without restarting postgres
Date: 2001-09-27 22:11:37
Message-ID: Pine.LNX.4.30.0109271809270.9046-100000@hindang.msuiit.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


i'm using

pg_ctl -l /var/log/pgsql/logfile start

to start my postgres. So whenever i look at the log files i just

tail -f /var/log/pgsql/logfile

that seems to do the trick.

hope this helps,

herbert

On Thu, 27 Sep 2001, Rainer Mager wrote:

> Hi all,
>
> Is there any way to alter postgres' debug levels without restarting it?
> Specifically I sometimes need to turn on query logging but I don't want to
> restart the backend.
>
>
> Thanks,
>
> --Rainer
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message david 2001-09-27 23:07:37 Re: pg_dump fails
Previous Message Dave VanAuken 2001-09-27 20:30:30 pgsql and SSL