Postgres Pro
Downloads
Home   >   mailing lists

Re: Snapshot as Backup - Mailing list pgsql-admin

From Sai Hertz And Control Systems
Subject Re: Snapshot as Backup
Date
Msg-id 40045575.60007@sancharnet.in
Whole thread Raw
In response to Snapshot as Backup  ("Ed Murphy" <emurphy1@email.arizona.edu>)
Responses Re: Snapshot as Backup
List pgsql-admin
Tree view 
Dear Ed Murphy  ,

> 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?
>
Yes if the snapshot (filesystem) backup and restore is performed when
postmaster is NOT running  you can reproduce it.
I have done this with command
dump  <-- for file system backup
Filesystem ext3

Regards
Vishal Kashyap

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: psql Automatic login In Bash Script
Next
From: Sai Hertz And Control Systems
Date:
Subject: Re: psql Automatic login In Bash Script