-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 03/29/07 23:56, Gerald Timothy G Quimpo wrote: [snip] > > How do people take consistent backups of very large > databases on Linux/FreeBSD? I'm aware of PITR, but > might not be able to set aside a box with enough > drives for it. LVM Snapshot? performance issues with > LVM, etc? If PG allows partitioned tables to span schemas, then I'd do that, so that only one (relatively small, say quarterly or semi-annual) schema is ever "hot" and needs to be backed up. - -- Ron Johnson, Jr. Jefferson LA USA Give a man a fish, and he eats for a day. Hit him with a fish, and he goes away for good! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGESHPS9HxQb37XmcRAmZFAKCkRvh6fMlU4CUj25F5BT2L56C0fgCgn5wS c+h/WQR3WHy9BvZ6lryIIqQ= =OdEt -----END PGP SIGNATURE-----
