X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E32179DCAD2 for ; Fri, 24 Mar 2006 19:19:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77742-05 for ; Fri, 24 Mar 2006 19:19:59 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 046D99DCAA5 for ; Fri, 24 Mar 2006 19:19:53 -0400 (AST) Received: (qmail invoked by alias); 24 Mar 2006 23:19:55 -0000 Received: from dslb-084-063-041-148.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.41.148] by mail.gmx.net (mp032) with SMTP; 25 Mar 2006 00:19:55 +0100 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: Continuous On-line Backups Date: Sat, 25 Mar 2006 00:19:52 +0100 User-Agent: KMail/1.8.3 Cc: "Thomas F. O'Connell" References: <33C7314B-CE32-4E5A-8D73-1AA0B32EBB84@sitening.com> In-Reply-To: <33C7314B-CE32-4E5A-8D73-1AA0B32EBB84@sitening.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200603250019.53577.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.129 required=5 tests=[AWL=0.129] X-Spam-Score: 0.129 X-Spam-Level: X-Archive-Number: 200603/249 X-Sequence-Number: 21006 Thomas F. O'Connell wrote: > So long as I know that nothing will access the recovery database with > write activity, is there a way to toggle the continuity so that I > could allow recovery to complete on a nightly basis, pg_dump the > recovered database (a read-only action), and then resume recovering? Even a read-only action uses up transaction numbers and other things, so I'd expect that to be a problem. -- Peter Eisentraut http://developer.postgresql.org/~petere/