Postgres logs w/ Logrotate

From: Renê Salomão <rene(at)ibiz(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgres logs w/ Logrotate
Date: 2003-03-28 14:35:45
Message-ID: 20030328113545.516faffb.rene@ibiz.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi list,

Is there any extra configuration to run postgresql 7.3.2 logs
with logrotate?
I tried the following script at /etc/logrotate.d:

/var/log/postgresql/postgresql.log {
daily
rotate 5
compress
create
}

the problem is that after it does its first rotation (create a
compressed copy of the log) and the new log file created, any new
message originated from postgresql is not saved in log file...

I do start postgres with:

pg_ctl start -o -i -l /var/log/postgresql/postgresql.log

What am I doing wrong? Does Postgresql need to be restarted? How can I
do it?

Tkns
-----------------------------
Renê Salomão
Ibiz Tecnologia -- www.ibiz.com.br
(011) 5579-3178 - R. 211

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message LaBranche, Kevin 2003-03-28 15:36:34 Executing SQL batch file
Previous Message A.Bhuvaneswaran 2003-03-28 05:06:31 Re: Postgres logs