X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BF753D1B532 for ; Thu, 16 Oct 2003 22:36:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 02901-03 for ; Thu, 16 Oct 2003 19:36:03 -0300 (ADT) Received: from gsy_sbs_1.cisx.com (unknown [213.133.202.58]) by svr1.postgresql.org (Postfix) with ESMTP id 6A7DAD1B553 for ; Thu, 16 Oct 2003 19:35:59 -0300 (ADT) Received: from DEMOLITION ([192.168.100.22]) by gsy_sbs_1.cisx.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id 44HZCJLQ; Thu, 16 Oct 2003 23:25:44 +0100 Message-ID: <001001c39435$dbd82920$1664a8c0@DEMOLITION> From: "Donald Fraser" To: "[ADMIN]" References: <200310160949.59442.josh@agliodbs.com> <20031016130637.535f633f.threshar@torgo.978.org> Subject: Re: [PERFORM] backup/restore - another area. Date: Thu, 16 Oct 2003 23:35:48 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4927.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/192 X-Sequence-Number: 10753 > > Jeff, > > > > > The downside is > > > this method will only work on that specific version of PG and it > > > isn't the"cleanest" thing in the world since you are essentially > > > simulating a power failure to PG. Luckly the WAL works like a champ. > > > Also, these backups can be much larger since it has to include the > > > indexes as well. but this is a price you have to pay. > > > > The other downside is, of course, that the database needs to be shut > > down. > > > > I left the DB up while doing this. > > Even had a program sitting around committing data to try and corrupt > things. (Which is how I discovered I was doing the snapshot wrong) > > You could do pg_ctl stop; snapshot; pg_ctls tart for a "clean" image. > Since this seems to work for you, would you be kind enough to post the shell script for doing the snapshot with LVM. Regards Donald Fraser