Greetings,

Does pg open its logfile every time it writes or does it open the file and
hold it open as long as the postmaster is running?  Do I have to stop the
postmaster to rotate the logfile out or can I just move or delete it at any
time and pg will create a new logfile the next time it writes?

Thank you,
Matthew

Mon, 27 Dec 1999 08:29:05 -0500
Matthew Hagerty <matthew@venux.net>
Logfile rotation
Matthew Hagerty <matthew@venux.net> writes:
> Does pg open its logfile every time it writes or does it open the file and
> hold it open as long as the postmaster is running?

If you do the usual
	postmaster >logfile 2>&1
then the logfile is actually opened by the shell before the postmaster
ever starts; the postmaster has no way to close and re-open it.  So,
no, you can't rotate the logfile transparently in that scenario.

I believe there's a compile-time option to use syslog instead, which
probably works better for this (assuming you have syslog).

			regards, tom lane

Mon, 27 Dec 1999 11:14:09 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Logfile rotation 