Skip site navigation (1) Skip section navigation (2)

Re: Built-in log rotation

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Kris Kiger <kris(at)musicrebellion(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Built-in log rotation
Date: 2007-02-19 15:53:08
Message-ID: 20070219155308.GN28395@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
Kris Kiger wrote:
> Greetings!  I've been doing some research into log rotation software and 
> ran into this, while looking through the postgres site:
> 
> "There is a built-in log rotation program, which you can use by setting 
> the configuration parameter redirect_stderr to true in postgresql.conf."
> http://www.postgresql.org/docs/8.1/interactive/logfile-maintenance.html
> 
> My question is, how does it rotate logs?

It closes the old file and opens a new one -- new name, new file
descriptor, so the problem you mention below doesn't exist anymore.

> Does it perform a 
> copy/truncate of the logfile?  I know in older versions of postgres, if 
> you tried to move the log file, and create one with the same name, the 
> server wouldn't actually write to it without a restart...at least in 
> linux it wouldn't.

This code is "new" (only two years old).

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-admin by date

Next:From: Ray StellDate: 2007-02-19 16:19:37
Subject: log_duration?
Previous:From: Kris KigerDate: 2007-02-19 15:34:40
Subject: Built-in log rotation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group