Thread: HUPing a database

HUPing a database

From
Philip Molter
Date:
I'm doing logging of PG information, and I'd like to rotate the logs.
What's the proper way to HUP the server once the logs have been
rotated?

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip@datafoundry.net

Re: HUPing a database

From
Peter Eisentraut
Date:
Philip Molter writes:

> I'm doing logging of PG information, and I'd like to rotate the logs.
> What's the proper way to HUP the server once the logs have been
> rotated?

There isn't one.  You're better off piping the postmaster output through a
separate rotate program.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


Re: HUPing a database

From
Philip Molter
Date:
On Fri, Jul 06, 2001 at 06:15:47PM +0200, Peter Eisentraut wrote:
: Philip Molter writes:
:
: > I'm doing logging of PG information, and I'd like to rotate the logs.
: > What's the proper way to HUP the server once the logs have been
: > rotated?
:
: There isn't one.  You're better off piping the postmaster output through a
: separate rotate program.

Hrmm, are there plans to implement this feature?  That seems like an
*EXTREMELY* large oversight, to not allow for a simple HUP for
something as universal as daily log rotation.

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip@datafoundry.net

Re: HUPing a database

From
Bruce Momjian
Date:
> : There isn't one.  You're better off piping the postmaster output through a
> : separate rotate program.
>
> Hrmm, are there plans to implement this feature?  That seems like an
> *EXTREMELY* large oversight, to not allow for a simple HUP for
> something as universal as daily log rotation.

How about using syslog logging?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: HUPing a database

From
Philip Molter
Date:
On Fri, Jul 06, 2001 at 02:43:44PM -0400, Bruce Momjian wrote:
: > : There isn't one.  You're better off piping the postmaster output through a
: > : separate rotate program.
: >
: > Hrmm, are there plans to implement this feature?  That seems like an
: > *EXTREMELY* large oversight, to not allow for a simple HUP for
: > something as universal as daily log rotation.
:
: How about using syslog logging?

Well, I'm using the logs to track down a locking issue, so I'd rather
not send all that output to syslog.  Someone suggested running it into
a pipe, so I'll probably do that.  I was just surprised that you can't
simply reload the server real quick to take care of those things.

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip@datafoundry.net