X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2DE7DD1B385 for ; Wed, 21 Jul 2004 11:54:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81908-02 for ; Wed, 21 Jul 2004 14:53:58 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 36311D1B179 for ; Wed, 21 Jul 2004 11:53:53 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i6LErnlR008660; Wed, 21 Jul 2004 10:53:49 -0400 (EDT) To: Klaus Naumann Cc: Simon Riggs , markw@osdl.org, pgman@candle.pha.pa.us, pgsql-patches@postgresql.org Subject: Re: [HACKERS] Point in Time Recovery In-reply-to: References: <200407201536.i6KFa7122392@mail.osdl.org> <1090344478.3377.8.camel@stromboli> <4589.1090388994@sss.pgh.pa.us> Comments: In-reply-to Klaus Naumann message dated "Wed, 21 Jul 2004 09:49:01 +0200" Date: Wed, 21 Jul 2004 10:53:49 -0400 Message-ID: <8659.1090421629@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/375 X-Sequence-Number: 12045 Klaus Naumann writes: > Simon doesn't mean the recovery part. Instead he means the "normal" > startup of the server. It has to be absolutely clear (in the logfile!) if > the server was started in archive mode or not. Otherwise you always have > to guess. Why would you guess? "SHOW archive_command" will tell you, without question, at any time. I don't see the point of placing such a message in the postmaster log --- in normal circumstances the postmaster will still be running long after its starting messages have been discarded due to log rotation. Also, the current implementation allows you to stop and start archiving on-the-fly, so a start-time message would be an unreliable guide to what the postmaster is actually doing at the moment. regards, tom lane