On Oct 17, 2006, at 10:43 AM, mengel(at)notes(dot)cc(dot)sunysb(dot)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.