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(at)enterprisedb(dot)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)
rsync WAL
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-----