Re: 8.3 RC1 - Logging and filenames

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andy Shellam" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: 8.3 RC1 - Logging and filenames
Date: 2008-01-12 17:21:43
Message-ID: 9228.1200158503@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Andy Shellam" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> writes:
> Many services use a single log file and just keep adding to it - that's the
> way I'd prefer to set PostgreSQL up, simply so I can predict what the log
> file's name is. Our rotation system will then rotate the log and keep the
> name in the same format as all our other services.

I wonder exactly how your rotation system is going to accomplish that.
PG doesn't support re-opening its logfile on SIGHUP (and even if it did,
you'd have to find and SIGHUP all the relevant processes ... at the same
time ...)

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Haumer 2008-01-12 18:27:19 Re: Restore dump into different databases/owners
Previous Message Tom Lane 2008-01-12 17:15:25 Re: Restore dump into different databases/owners