On Thu, Jan 03, 2008 at 11:15:23AM +0800, Ow Mun Heng wrote:
> I'm just wetting my hands with slony and during the setup of the slave,
> I did and dump and restore of the master DB to the Slave DB.
Nope, you don't need to do that. You need a copy of the _schema_ on the
target machine. But slony will remove all the contents and build the
replica anew.
> can someone confirm this? It _is_ taking long time (for slony) to do the
> \copy (~60GB in multiple tables being replicated, including (on the fly)
> index creation)
It takes approximately the same time as it would to do a psql -h
[remotehost] -f dumpfile.sql restore (i.e. copying the entire data contents
across the network).
A