Re: Postgres/Postmaster logging and log rotation - Mailing list pgsql-admin

From Robert Hentosh
Subject Re: Postgres/Postmaster logging and log rotation
Date
Msg-id 20010319070041.B30102@fnord.io.com
Whole thread Raw
In response to Re: Postgres/Postmaster logging and log rotation  (root <root@dennis.veritime.com>)
List pgsql-admin
Try the copytruncate directive in the logrotate configuration file. (See 'man logrotate').  This should allow it to
workwithout restarting postgresql. But as the man file says, there is a small chance of losing some log entries. 

On Wed, Mar 07, 2001 at 10:37:30AM -0500, root wrote:
> Be sure to stop postgres, rotate your log (or move it out of the /var/log
> directory and then rotate it), and restart postgresql.  That will solve your
> problem.  Hopefully you don't need a 24x7 available database as this might take
> a few seconds for your server to complete.
>
> On Wed, 07 Mar 2001, William L James wrote:
> > Hi there:
> >
> > We are running PostgreSQL 7.0.2 on RedHat Linux 6.2 and
> > have encountered a few strange problems that continue to
> > elude us - namely INSERT and DELETE functions that end
> > abnormally, but do not include any information as to why (the
> > JDBC connection just seems to have gone away).  Trying to
> > further diagnose the situation, I have been successful in starting
> > the Postgres logging (by including the following in the postgresql
> > script - su -l postgresql -c "/usr/bin/pg_ctl -D $PGDATA -p
> > /usr/bin/postmaster start >>/var/log/postgresql 2>&1"), but
> > when the weekly logrotate.d function kicks in, Postgres logging
> > stops.  We also have trouble doing a simple restart - I wind up
> > having to do a stop and then a start minutes later.  Can anyone
> > explain how to get Postgres to log and to be able to rotate the
> > log periodically?  Any information would be appreciated.
> >
> > Thanks,
> > Bill James

> --
> Thanks,
>
>
> Rodney Hampton

pgsql-admin by date:

Previous
From: "Peter Schuller"
Date:
Subject: Re: Backing up postgresql databases
Next
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: Backing up postgresql databases