Hi guys,

What is the correct signal (and number) that should be sent to postgres 
when you want to roll its logs?

I can't seem to see the answer...

Chris



Tue, 30 Sep 2003 12:27:11 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
signal to send to postgres when log rolling
Christopher Kings-Lynne wrote:
> Hi guys,
> 
> What is the correct signal (and number) that should be sent to postgres 
> when you want to roll its logs?
> 
> I can't seem to see the answer...

There isn't one.  You have to pipe into something like Apache's
rotatelogs or use syslog.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Tue, 30 Sep 2003 00:31:41 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: signal to send to postgres when log rolling
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> What is the correct signal (and number) that should be sent to postgres 
> when you want to roll its logs?

There is no log-rolling functionality in PG.  Use syslog, or pipe the
postmaster's output into something like Apache's logrotate program.

			regards, tom lane

Tue, 30 Sep 2003 00:51:21 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: signal to send to postgres when log rolling 