Hi,
We use greenplum (based on PG 8.2.13) for our data warehouse. We're on a 10node system, with 1 master that coordinates the work.  We use before row triggers a lot to implement at rest encryption.

We're bringing up an additional system an need a mechanism for keeping the two clusters in sync.
We have a large installation (14000 tables,  14TB).  It's mostly batch updated, with most tables only getting <100k inserts/updates per day.  Our  biggest table  might do 5m rows/day.
We have about 1500 core tables that we'd want to replicate.

Could people comment on if this would be an appropriate use case for slony?
Thanks


Doug Little

Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide
500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas.Little at orbitz.com<mailto:Douglas.Little at orbitz.com>
 [cid:image001.jpg at 01CC0E56.4D172300]   orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20110509/f722442a/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2337 bytes
Desc: image001.jpg
Url : http://lists.slony.info/pipermail/slony1-general/attachments/20110509/f722442a/attachment.jpg