Postgres Pro
Downloads
Home   >   mailing lists

Thread: postmaster and logrotate

postmaster and logrotate

From
Dima Tkach
Date:
Hi, everybody!

I was wonderring if there is a way to make logrotate work with postgres
logs?
More precisely, the question is - is there any way to tell a running
postmaster process to reopen its log file?
I tried kill -HUP ... but that doesn't seem to do anything...

Is there just no way to do what I want?

Thanks!

Dima

Re: postmaster and logrotate

From
Bruce Momjian
Date:
Dima Tkach wrote:
> Hi, everybody!
>
> I was wonderring if there is a way to make logrotate work with postgres
> logs?
> More precisely, the question is - is there any way to tell a running
> postmaster process to reopen its log file?
> I tried kill -HUP ... but that doesn't seem to do anything...
>
> Is there just no way to do what I want?

Docs say pipe into logrotate:

    http://developer.postgresql.org/docs/postgres/logfile-maintenance.html

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: postmaster and logrotate

From
Claudio Succa
Date:
Il lun, 2003-12-22 alle 19:40, Dima Tkach ha scritto:
> Hi, everybody!
>
> I was wonderring if there is a way to make logrotate work with postgres
> logs?
> More precisely, the question is - is there any way to tell a running
> postmaster process to reopen its log file?
> I tried kill -HUP ... but that doesn't seem to do anything...
>
> Is there just no way to do what I want?
>
> Thanks!
>
> Dima

In /etc/logrotate.d create a file named i.e. postgres with more or less
the following contents:

/var/log/postgres.log {
        weekly
        missingok
        rotate 4
        copytruncate
        compress
        delaycompress
        notifempty
}

Pls notate the 'copytruncate' option which enables the routing of the
output of syslogd to a new file.

Claudio

--
Claudio Succa
PERTEL - Torino - Italy
+39-011-437.4141
http://www.pertel.it
http://www.uniassist.it