Josh Berkus josh
Mon May 9 19:03:52 PDT 2005
Folks,

I've discussed this with Darcy some, but wanted to get the benefit of others' 
experience.

We have a large database (100GB and growing).   On a nightly basis, we will be 
performing ETL to load daily data into this database.  Then it will copy over 
to the slave server using PITR.

During the day, we have 5 tables which we want to replicate via Slony-I 
between the master and slave.  At the beginning of the day, these tables will 
be empty.  

So, question, after we've copied the database with PITR, is there an easy way 
to turn the copy into a slave, or would it be better/easier to re-install 
Slony on the slave and subscribe the empty tables?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


More information about the Slony1-general mailing list