Re: [7.0.2] rotating log files ... - Mailing list pgsql-admin

From Palle Girgensohn
Subject Re: [7.0.2] rotating log files ...
Date
Msg-id 39AAF782.5E5B392C@partitur.se
Whole thread Raw
In response to [7.0.2] rotating log files ...  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [7.0.2] rotating log files ...  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Hi,

Apart from using syslog, which apparently work fine (?) with
7.0.2, the 'rotatelogs' utility from apache's support dir is
great (No need to hack one up, as Alfred Perlstein suggest;
this babe been around and is quite stable).

Of course, you need to stop the server once, but I guess other
ways have been thouroughly dicussed in already :)

Enclosed is a Bournce shell script showing how I start postgres
on developers' machines [debug on] (run as root, will su pgsql)

On syslog... is syslog support reliable now? If so,
admin/pg-options.htm should be updated:

...Unfortunately many functions call directly printf() to print
their messages to stdout or stderr and this output can't be
redirected to syslog or have timestamps in it....

Cheers,
Palle

The Hermit Hacker wrote:
>
> can someone recommend on how to rotate the following log files without
> having to stop/start the server?
...
> suggestions?
>
> Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org

Attachment

pgsql-admin by date:

Previous
From: Ragnar Kjørstad
Date:
Subject: Re: [7.0.2] rotating log files ...
Next
From: Palle Girgensohn
Date:
Subject: Cannot vacuum! Stops on first table, pg_type