X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 05F08329C83 for ; Thu, 7 Oct 2004 21:41:52 +0100 (BST) 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 07668-01 for ; Thu, 7 Oct 2004 20:41:40 +0000 (GMT) Received: from cmailm4.svr.pol.co.uk (cmailm4.svr.pol.co.uk [195.92.193.211]) by svr1.postgresql.org (Postfix) with ESMTP id 6EC2232A3DE for ; Thu, 7 Oct 2004 21:41:39 +0100 (BST) Received: from modem-815.leopard.dialup.pol.co.uk ([217.135.147.47] helo=happyplace) by cmailm4.svr.pol.co.uk with smtp (Exim 4.14) id 1CFf4z-0000lC-LP; Thu, 07 Oct 2004 21:41:37 +0100 From: "Simon Riggs" To: "Goulet, Dick" , Cc: Subject: Re: Multiple WALs for PITR ? Date: Thu, 7 Oct 2004 21:58:24 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <4001DEAF7DF9BD498B58B45051FBEA6501B9D709@25exch1.vicorpower.vicr.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal 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: 200410/120 X-Sequence-Number: 15113 >Goulet, Dick > As an Oracle DBA primarily, moving more towards PostGreSQL as time > passes, the "alter system switch logfile" command is very often used at > the end of a hot backup to force a logfile switch and consequently > provide a full archive log set. The command causes the database engine > to cease using the current online redo log and have it archived to the > archive log destination. This is the only way to be sure that all > required archive logs are present in a backup to reconstitute the > database at another location. > Yep, know what it does - just wanted to check that people really used it. I always felt I did that as a precaution rather than for good reason. OK - 8.1 it is then, Best Regards Simon Riggs