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" <[email protected]<mailto:[email protected]>> Date: Mon, 9 May 2011 12:35:11 -0700 To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> [cid:[email protected]] 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/>
<<inline: image001.jpg>>
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
