On May 5, 2005, at 5:03 PM, Grant McLean wrote:
Why would you need to take anything down to run pg_dump? And surely bringing a slave up to speed using Slony would be much slower than dump/restore?
You'd need to stop client access to PG to prevent changes from occuring between when you take the dump & when you restore on the slave and hten fire up dbmirror. Although it might work if you install the dbmirror triggers, then dump & restore.
Slony uses the COPY interface to read/load data. This is the same method used by pg_dump so the only throttle will be the network.
-- Jeff Trout <jeff@xxxxxxxxxxxxx> http://www.jefftrout.com/ http://www.stuarthamm.net/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
