Fri Jan 11 13:32:54 PST 2008
- Previous message: [Slony1-general] What is the risk from running pg_dump on a replica
- Next message: [Slony1-general] What is the risk from running pg_dump on a replica
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Tim Goodaire <tgoodair at ca.afilias.info> writes: > You could take your backup from the origin instead of the subscriber. You can do considerably better than that... You need to take the *SCHEMA DUMP* from the origin, which isn't hugely expensive. You can then take a data-only dump from a subscriber. You can then meld them together, to give you a Proper Schema, and a dump that *didn't* have to open a 4-hour-long transaction against the origin node. -- (format nil "~S@~S" "cbbrowne" "cbbrowne.com") http://linuxfinances.info/info/sap.html "So, does this mean goodbye to the "Bluescreen of Death" and hello to the "Bluescreen of Holy Vengeance?"" -- Observed on Slashdot after hearing Al Qaeda terrorists may have hacked on Windows XP...
- Previous message: [Slony1-general] What is the risk from running pg_dump on a replica
- Next message: [Slony1-general] What is the risk from running pg_dump on a replica
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list