Thread: log file maintenance

log file maintenance

From
yusuf0478@netscape.net (David Wendy)
Date:
I have logrotate set up for my databases, the problem is that I alwayz
have to restart my server after the log file is rotated.

What do I do after the logrotate so I don't have to restart the db
server?

The ways I've tried to start the server:
pg_ctl start -D .../data -l logfile
and
pg_ctl start -D .../data | cat - >> logfile

At the moment, I'm using the logrotate script that comes with redhat.
I basically just had to create a logrotate.conf file and use it to
logrotate.

Re: log file maintenance

From
Oliver Elphick
Date:
On Mon, 2003-02-17 at 18:54, David Wendy wrote:
> I have logrotate set up for my databases, the problem is that I alwayz
> have to restart my server after the log file is rotated.
>
> What do I do after the logrotate so I don't have to restart the db
> server?
>
> The ways I've tried to start the server:
> pg_ctl start -D .../data -l logfile
> and
> pg_ctl start -D .../data | cat - >> logfile
>
> At the moment, I'm using the logrotate script that comes with redhat.
> I basically just had to create a logrotate.conf file and use it to
> logrotate.

Either of those methods will require the copytruncate option in the
logrotate configuration.  Does it have it?

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "And the angel answered and said unto the women, Fear
      ye not; for I know that ye seek Jesus, who was
      crucified. He is not here; for he is risen, as he
      said...Therefore be ye also ready; for in such an hour
      as ye think not the Son of man cometh."
                              Matthew 28:5,6; 24:44