Обсуждение: Recycle error logs

Поиск
Список
Период
Сортировка

Recycle error logs

От
adey
Дата:
Please advise if there is a way to start a fresh Postgresql error / output log at regular intervals?
We are tuning a "new toproduction" system, so I have all the SQL logged, but the file gets too big and cumbersome, so I'd like to start a new one each morning without restarting Postgres.

Re: Recycle error logs

От
Devrim GUNDUZ
Дата:
Hi,

On Sat, 2006-07-15 at 19:37 +1200, adey wrote:
> Please advise if there is a way to start a fresh Postgresql error /
> output log at regular intervals?

PostgreSQL 8.0.0 and above has a built-in log rotation mechanism. Check
postgresql.conf for this. See the section "Error reporting and logging".

log_rotation_age will help you to determine daily rotation. Also set
log_filename to point only to %Y-%m-%d .

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/



Re: Recycle error logs

От
Scott Marlowe
Дата:
On Sat, 2006-07-15 at 02:37, adey wrote:
> Please advise if there is a way to start a fresh Postgresql error /
> output log at regular intervals?
> We are tuning a "new toproduction" system, so I have all the SQL
> logged, but the file gets too big and cumbersome, so I'd like to start
> a new one each morning without restarting Postgres.

As mentioned previously, it's built into 8.0 and up.  If you're stuck on
a version before that, you can use apache's log rotator to do the job.

Something like this:

pg_ctl start | /usr/sbin/rotatelogs /logs/pgsql 86400

Re: Recycle error logs

От
adey
Дата:
Many thanks to all of you that helped with this.

On 7/18/06, Scott Marlowe <smarlowe@g2switchworks.com> wrote:
On Sat, 2006-07-15 at 02:37, adey wrote:
> Please advise if there is a way to start a fresh Postgresql error /
> output log at regular intervals?
> We are tuning a "new toproduction" system, so I have all the SQL
> logged, but the file gets too big and cumbersome, so I'd like to start
> a new one each morning without restarting Postgres.

As mentioned previously, it's built into 8.0 and up.  If you're stuck on
a version before that, you can use apache's log rotator to do the job.

Something like this:

pg_ctl start | /usr/sbin/rotatelogs /logs/pgsql 86400