Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C05052E2FE5 for ; Sat, 12 Jan 2008 13:21:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 70641-02 for ; Sat, 12 Jan 2008 13:21:44 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 556762E0135 for ; Sat, 12 Jan 2008 13:21:45 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m0CHLhPh009229; Sat, 12 Jan 2008 12:21:43 -0500 (EST) To: "Andy Shellam" cc: pgsql-admin@postgresql.org Subject: Re: 8.3 RC1 - Logging and filenames In-reply-to: <33671a790801120818i31f126b9ueac31f33ddb23063@mail.gmail.com> References: <33671a790801101445j7f3c8644wf41c1e6fced8bedc@mail.gmail.com> <12716.1200010137@sss.pgh.pa.us> <20080110162258.4b0d4991@commandprompt.com> <12963.1200011400@sss.pgh.pa.us> <33671a790801120818i31f126b9ueac31f33ddb23063@mail.gmail.com> Comments: In-reply-to "Andy Shellam" message dated "Sat, 12 Jan 2008 16:18:08 +0000" Date: Sat, 12 Jan 2008 12:21:43 -0500 Message-ID: <9228.1200158503@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/133 X-Sequence-Number: 27907 "Andy Shellam" 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