Thread: HUPing a database
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
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