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 C9D5ED1DB01 for ; Tue, 13 Jan 2004 17:16:14 +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 90339-05 for ; Tue, 13 Jan 2004 13:15:44 -0400 (AST) Received: from smtpgate.email.arizona.edu (deagol.email.Arizona.EDU [128.196.133.142]) by svr1.postgresql.org (Postfix) with ESMTP id 3186ED1DF7E for ; Tue, 13 Jan 2004 13:15:43 -0400 (AST) Received: from ilcd45 (ilcd45.ilc.arizona.edu [150.135.164.51]) by smtpgate.email.arizona.edu (Postfix) with ESMTP id B5B08272BAD for ; Tue, 13 Jan 2004 10:15:34 -0700 (MST) Reply-To: From: "Ed Murphy" To: Subject: Snapshot as Backup Date: Tue, 13 Jan 2004 10:15:34 -0700 Organization: The University of Arizona Message-ID: <000901c3d9f8$db4a1cd0$33a48796@ilc.arizona.edu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000A_01C3D9BE.2EEB44D0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at email.arizona.edu X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50 X-Spam-Level: X-Archive-Number: 200401/103 X-Sequence-Number: 11966 This is a multi-part message in MIME format. ------=_NextPart_000_000A_01C3D9BE.2EEB44D0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hello, =20 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? =20 Thanks, =20 Ed Murphy The University of Arizona ------=_NextPart_000_000A_01C3D9BE.2EEB44D0 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Message
Hello,
 
I'm using= Red Hat=20 Enterprise v2.1 and PostgreSQL v7.3.4.  Our hardware setup includes a = large=20 Storage Area Network (SAN).  The systems folks are going to utilize a= =20 snapshot type backup to backup the file system.  This snapshot will in= clude=20 PGDATA and all the PostgreSQL files.  My question is if I restore this= =20 snapshot will PostgreSQL work?  I know if doing a typical file system= =20 backup of PostgreSQL I must first stop the postmaster or the backup will no= t=20 produce a useable PostgreSQL system.  Is it necessary to stop the=20 postmaster for this snapshot backup also?
 
Thanks,
 
Ed=20 Murphy
The Unive= rsity of=20 Arizona
------=_NextPart_000_000A_01C3D9BE.2EEB44D0--