Since we use Slony (2.0.3) here for some things, and also run Greenplum, I asked one of our DBAs about this. Here is his reply:

Greenplum will not work with Slony since Greenplum's trigger has a major limitation.

The Greenplum trigger function doesn't allow any SQL execution or modification of the database. So Slony will not work since it relies on triggers to replicate.

See Sing

From: "Little, Douglas" <DOUGLAS.LITTLE at orbitz.com<mailto:DOUGLAS.LITTLE at orbitz.com>>
Date: Mon, 9 May 2011 12:35:11 -0700
To: "slony1-general at lists.slony.info<mailto:slony1-general at lists.slony.info>" <slony1-general at lists.slony.info<mailto:slony1-general at lists.slony.info>>
Subject: [Slony1-general] Slony use cases

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/834fbaec/attachment-0001.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/834fbaec/attachment-0001.jpg