X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9EAC0DBA97 for ; Thu, 17 Nov 2005 17:24:43 -0400 (AST) 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 44112-02 for ; Thu, 17 Nov 2005 21:24:43 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp103.rog.mail.re2.yahoo.com (smtp103.rog.mail.re2.yahoo.com [206.190.36.81]) by svr1.postgresql.org (Postfix) with SMTP id A69E4DBB05 for ; Thu, 17 Nov 2005 17:24:39 -0400 (AST) Received: (qmail 40899 invoked from network); 17 Nov 2005 21:24:40 -0000 Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@209.222.54.227 with login) by smtp103.rog.mail.re2.yahoo.com with SMTP; 17 Nov 2005 21:24:40 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id D1EE640E6; Thu, 17 Nov 2005 16:24:39 -0500 (EST) Date: Thu, 17 Nov 2005 16:24:39 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: restore challenge Message-ID: <20051117212439.GA26696@phlogiston.dyndns.org> References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> <60fypvgkol.fsf@dba2.int.libertyrms.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <60fypvgkol.fsf@dba2.int.libertyrms.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/233 X-Sequence-Number: 19606 On Thu, Nov 17, 2005 at 02:04:42PM -0500, Chris Browne wrote: > If your OS or disk hardware supports some sort of "snapshotting" > technology, so that you can grab a copy of the whole thing as an > instant atomic operation, that provides a way to grab a copy while > postmaster is running. If not, then you have to take a copy while the > postmaster is shut down. It's also worth noting that you _really really_ want to test that snapshotting capability. I've heard some people grumble about "it didn't work for me" or some such. There are others who've reported it works (and it ought to, if the snapshots work as advertised -- just be sure you know what the snapshots actually are). A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland