Re: log file maintenance

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: David Wendy <yusuf0478(at)netscape(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: log file maintenance
Date: 2003-02-19 10:02:46
Message-ID: 1045648965.1253.53.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)Elphick(at)lfix(dot)co(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Donald Fraser 2003-02-19 11:02:44 Re: uppercase = lowercase
Previous Message Tom Lane 2003-02-19 07:51:33 Re: uppercase = lowercase