Re: [ADMIN] Logrotate

[Luis Sousa]

Oliver Elphick wrote:

On Wed, 2002-11-20 at 10:14, Luis Sousa wrote:

Hi all,

I'm running postgresql 7.2.1 on a debian 3.0 machine and I want to do some log rotation, but I'm having some problems. The configuration that I'm using is:
In /etc/logrotate.d/postgres:
/var/log/postgres.log {
weekly
rotate 52
compress
delaycompress
notifempty
create 640 postgres postgres
sharedscripts
postrotate
/etc/init.d/postgresql restart > /dev/null
endscript
}

But when this is executed, always is returned the following error:

pg_ctl: Another postmaster may be running. Trying to start postmaster anyway.
pg_ctl: cannot start postmaster
Examine the log output.

Any sugestions !! What's wrong ?

You don't want to restart the postmaster; suppose someone has a
long-running query in progress at that moment. As to what is going
wrong, what does the log output say?

You should use copytruncate as a logrotate option, so that you will not
need to force the postmaster to close.

This is my (working) setup:

$ cat /etc/logrotate.d/postgresql
/var/log/postgres.log {
daily
rotate 10
copytruncate
delaycompress
compress
notifempty
create 640 postgres postgres
}

Oliver,

I'm using the definition that you refer but now I have a problem.
Now, after one rotate, postgres created an empty file, postgres.log, but is witing log on postgres.log.1.
Why's that ? Why didn't postgre started writing log in postgres.log, the new file that was created ?

Thanks in advance
Luis Sousa


--
Luis Sousa
Especialista de Inform?tica
Gabinete de Gest?o de Informa??o, ext: 7837
Campus de Gambelas
Universidade do Algarve, tel: 289800900

smime.p7s

Description: S/MIME Cryptographic Signature