Re: Slony v. DBMirror

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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/