| Lists: | pgsql-admin |
|---|
| From: | yusuf0478(at)netscape(dot)net (David Wendy) |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | log file maintenance |
| Date: | 2003-02-17 18:54:30 |
| Message-ID: | 535ddc4b.0302171054.14a489fc@posting.google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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.
| 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 |
| 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