X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D2EF69FB1F0 for ; Fri, 15 Sep 2006 09:47:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 66416-03 for ; Fri, 15 Sep 2006 09:47:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp-out3.blueyonder.co.uk (smtp-out3.blueyonder.co.uk [195.188.213.6]) by postgresql.org (Postfix) with ESMTP id C78329FB1E4 for ; Fri, 15 Sep 2006 09:47:26 -0300 (ADT) Received: from [172.23.170.144] (helo=anti-virus03-07) by smtp-out3.blueyonder.co.uk with smtp (Exim 4.52) id 1GOD6K-00024m-Ot for pgsql-admin@postgresql.org; Fri, 15 Sep 2006 13:47:24 +0100 Received: from [82.44.23.191] (helo=DonAcer) by asmtp-out2.blueyonder.co.uk with smtp (Exim 4.52) id 1GOD6K-00085F-7V for pgsql-admin@postgresql.org; Fri, 15 Sep 2006 13:47:24 +0100 Message-ID: <000601c6d8c5$161acd50$6464a8c0@DonAcer> From: "Donald Fraser" To: "[ADMIN]" Subject: Odd behaviour with WAL and pg_stop_backup Date: Fri, 15 Sep 2006 13:47:21 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200609/148 X-Sequence-Number: 23062 PostgreSQL 8.0.7 OS: Linux Red Hat 4.0 We have been testing the on-line backup of PostgreSQL and after issuing a pg_stop_backup() PostgreSQL is still using the archive command, as set in postgresql.conf, for every new WAL block generated. It appears the only way to truly stop it from using the archive command is to edit the postgresql.conf file, remove the archive command and either issue a SIGHUP or a server restart. Can someone confirm that this is the correct behaviour or not? Thanks in advance, Donald Fraser