Re: File system snapshots for multiple file systems

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, Apr 07, 2008 at 03:03:41PM -0400, Jonah H. Harris wrote:
> On Mon, Apr 7, 2008 at 2:58 PM, Heikki Linnakangas
> <heikki@enterprisedb.com> wrote:
> >  Incidentally, I looked at this stuff just a couple of days ago, and it

[...]

> Or checkpoint, yes?  I don't see tar backing up large (100+GB)
> databases in < 5 minutes.

Checkpoinitng is definitely coolest. If your file system doesn't do
that, rsync is a good poor man's replacement:
 first rsync (takes long)             (or work from an older backup) pg_start_backup(...) rsync (should be much faster)
rsyncWAL pg_stop_backup()
 

I regularly rsync moderately active 500GB filesystems on fairly feeble
hardware in about 5-10 minutes (for daily backups).

Regards
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFH+yEnBcgs9XrR2kYRAg00AJ4+RXKN9apDd1y6EcP+fkJbIRL0uwCfRcD/
KEDesKvCvSA4CzhomRJJ9Zg=
=Nw8x
-----END PGP SIGNATURE-----