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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
