-----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
> <[EMAIL PROTECTED]> 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-----
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
