Re: [OT] Slony (initial) Replication - Slow

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