HUPing a database

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

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

: 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

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