Re: Database logging.... Recycle server logs ??? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database logging.... Recycle server logs ???
Date
Msg-id 4864.1042488639@sss.pgh.pa.us
Whole thread Raw
In response to Database logging.... Recycle server logs ???  ("codeWarrior" <GPatnude@adelphia.net>)
List pgsql-admin
"codeWarrior" <GPatnude@adelphia.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-maintenance.html

            regards, tom lane

pgsql-admin by date:

Previous
From: "codeWarrior"
Date:
Subject: Database logging.... Recycle server logs ???
Next
From: Laurette Cisneros
Date:
Subject: Re: crypto?