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 75E7AD84B6 for ; Thu, 17 Nov 2005 23:18:18 -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 32257-04 for ; Fri, 18 Nov 2005 03:18:21 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5AF93D78B6 for ; Thu, 17 Nov 2005 23:18:15 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jAI3IChQ025470 for ; Fri, 18 Nov 2005 03:18:12 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jAI33ev5015561 for pgsql-admin@postgresql.org; Fri, 18 Nov 2005 03:03:40 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: restore challenge Date: Thu, 17 Nov 2005 21:58:44 -0500 Organization: cbbrowne Computing Inc Lines: 27 Message-ID: References: <012701c5ea9a$dbab31a0$5605a8c0@ng3054> <60fypvgkol.fsf@dba2.int.libertyrms.com> <20051117212439.GA26696@phlogiston.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, berkeley-unix) Cancel-Lock: sha1:hFgdtkBXypNuKyUtX07ESSiTEU8= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.917 required=5 tests=[ALL_TRUSTED=-1.44, AWL=-0.290, INFO_TLD=0.813] X-Spam-Score: -0.917 X-Spam-Level: X-Archive-Number: 200511/234 X-Sequence-Number: 19607 > 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). To add a grumble, of sorts... People get all excited about separating WAL onto separate disk, to improve performance. Unfortunately, if you do that, that separates the database into two portions, "splitting the atom," as it were. You'll no longer be able to get that atomic snapshot. Oops. -- output = reverse("moc.liamg" "@" "enworbbc") http://linuxdatabases.info/info/spreadsheets.html "I've seen a look in dogs' eyes, a quickly vanishing look of amazed contempt, and I am convinced that basically dogs think humans are nuts." -- John Steinbeck