Postgres Pro
Downloads
Home   >   mailing lists

Snapshot as Backup - Mailing list pgsql-admin

From Ed Murphy
Subject Snapshot as Backup
Date
Msg-id 000901c3d9f8$db4a1cd0$33a48796@ilc.arizona.edu
Whole thread Raw
Responses Re: Snapshot as Backup
Re: Snapshot as Backup
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: qq
Next
From: "Matt Clark"
Date:
Subject: Re: Snapshot as Backup