-----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-----