Wait, so are you copying the entire database nightly with PITR? As in, 
will you need to recreate the Slony environment on a daily basis?

Also, didn't you see Tom's recent rant about the spelling of "weird"... 
:P

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC

Strategic Open Source: Open Your i?

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On May 9, 2005, at 1:03 PM, Josh Berkus wrote:

> 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?