X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3FF13D1B499 for ; Tue, 13 Jan 2004 17:59:49 +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 01545-01 for ; Tue, 13 Jan 2004 13:59:18 -0400 (AST) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id B3134D1D889 for ; Tue, 13 Jan 2004 13:59:16 -0400 (AST) Received: from solent (82-68-95-1.dsl.in-addr.zen.co.uk [82.68.95.1]) by bayswater1.ymogen.net (Postfix) with ESMTP id 3586A96DFA; Tue, 13 Jan 2004 17:59:10 +0000 (GMT) From: "Matt Clark" To: , Subject: Re: Snapshot as Backup Date: Tue, 13 Jan 2004 17:59:09 -0000 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_029E_01C3D9FE.F1A72710" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <000901c3d9f8$db4a1cd0$33a48796@ilc.arizona.edu> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/104 X-Sequence-Number: 11967 This is a multi-part message in MIME format. ------=_NextPart_000_029E_01C3D9FE.F1A72710 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit MessageThe consensus from previous discussions (search for 'LVM' in the archives) is essentially that it definitely *should* work, some people *do* use it successfully, but that you *must* test it thoroughly in your own setup under heavy write load before relying on it. PG will believe it has 'crashed' when you start it from a restored snapshot, and PG is designed to recover perfectly well from crashes. If you stop the postmaster before the snapshot is taken then it will definitely work fine. Matt -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Ed Murphy Sent: 13 January 2004 17:16 To: pgsql-admin@postgresql.org Subject: [ADMIN] Snapshot as Backup Hello, I'm using Red Hat Enterprise v2.1 and PostgreSQL v7.3.4. Our hardware setup includes a large Storage Area Network (SAN). The systems folks are going to utilize a snapshot type backup to backup the file system. This snapshot will include PGDATA and all the PostgreSQL files. My question is if I restore this snapshot will PostgreSQL work? I know if doing a typical file system backup of PostgreSQL I must first stop the postmaster or the backup will not produce a useable PostgreSQL system. Is it necessary to stop the postmaster for this snapshot backup also? Thanks, Ed Murphy The University of Arizona ------=_NextPart_000_029E_01C3D9FE.F1A72710 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Message
The=20 consensus from previous discussions (search for 'LVM' in the archives) is= =20 essentially that it definitely *should* work, some people *do* use it=20 successfully, but that you *must* test it thoroughly in your own setup unde= r=20 heavy write load before relying on it.
 
PG=20 will believe it has 'crashed' when you start it from a restored snapshot, a= nd PG=20 is designed to recover perfectly well from crashes.  If you stop the= =20 postmaster before the snapshot is taken then it will definitely work=20 fine.
 
Matt
-----Original Message-----
From:=20 pgsql-admin-owner@postgresql.org=20 [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Ed=20 Murphy
Sent: 13 January 2004 17:16
To:=20 pgsql-admin@postgresql.org
Subject: [ADMIN] Snapshot as=20 Backup

Hello,
 
I'm usi= ng Red Hat=20 Enterprise v2.1 and PostgreSQL v7.3.4.  Our hardware setup includes = a=20 large Storage Area Network (SAN).  The systems folks are going to ut= ilize=20 a snapshot type backup to backup the file system.  This snapshot wil= l=20 include PGDATA and all the PostgreSQL files.  My question is if I re= store=20 this snapshot will PostgreSQL work?  I know if doing a typical file= =20 system backup of PostgreSQL I must first stop the postmaster or the backu= p=20 will not produce a useable PostgreSQL system.  Is it necessary to st= op=20 the postmaster for this snapshot backup also?
 
Thanks,
 
Ed=20 Murphy
The Uni= versity of=20 Arizona
------=_NextPart_000_029E_01C3D9FE.F1A72710--