From: | "codeWarrior" <GPatnude(at)adelphia(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Database logging.... Recycle server logs ??? |
Date: | 2003-01-13 21:40:10 |
Message-ID: | avvbbi$i61$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:4864(dot)1042488639(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "codeWarrior" <GPatnude(at)adelphia(dot)net> writes:
> > I noticed that the server generated logfile gets real big real fast --
(15
> > queries and it's already at 1.5MB) -- Is there a switch / option to
recycle
> > the server logs periodically ???
>
> The recommended procedure is not to use pg_ctl's -l switch, but to pipe
> output from it into a log-rotating script. The rotatelogs script from
> the Apache distribution works well, or you can roll your own. See
>
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/logfile-maintena
nce.html
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
Thanks Tom -- Of course -- I located that section of the manual immediately
after my post... I will use logrotate....
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser | 2003-01-13 21:47:22 | Re: query problem |
Previous Message | Patrick Meylemans | 2003-01-13 21:20:49 | SI buffer overflow |