Skip site navigation (1) Skip section navigation (2)

Re: Snapshot as Backup

From: Sai Hertz And Control Systems <sank89(at)sancharnet(dot)in>
To: emurphy1(at)email(dot)arizona(dot)edu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Snapshot as Backup
Date: 2004-01-13 20:30:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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

Vishal Kashyap

In response to


pgsql-admin by date

Next:From: Sai Hertz And Control SystemsDate: 2004-01-13 20:32:28
Subject: Re: psql Automatic login In Bash Script
Previous:From: Peter EisentrautDate: 2004-01-13 20:05:15
Subject: Re: psql Automatic login In Bash Script

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group