Re: Database logging.... Recycle server logs ???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "codeWarrior" <gpatnude(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database logging.... Recycle server logs ???
Date: 2003-01-13 20:10:39
Message-ID: 4864.1042488639@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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-maintenance.html

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tim Ellis 2003-01-13 20:11:13 Re: Encrypted Passwords
Previous Message helen liu 2003-01-13 16:44:01 query probelm