Re: Fast backup/restore - Mailing list pgsql-general

From Vivek Khera
Subject Re: Fast backup/restore
Date
Msg-id 11D9DE71-1916-419B-B428-FE8F6136643A@khera.org
Whole thread Raw
In response to Re: Fast backup/restore  (mengel@notes.cc.sunysb.edu)
Responses Re: Fast backup/restore
List pgsql-general

On Oct 17, 2006, at 10:43 AM, mengel@notes.cc.sunysb.edu wrote:

We just tar/gzip the entire data directory.  It takes all of 20 sec.  We've successfully restored from that also.  The machine you are restoring to *must* be running the save version of postgresql you backed up from. 

If you successfully backed up in 20 seconds, then you have a tiny DB.  Also, if you successfully restored from that style backup, your DB must not be written to much, or you were extremely lucky to get a consistent state.

Attachment

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Database users Passwords
Next
From: Shane Ambler
Date:
Subject: Re: Database users Passwords