Hi Bart, On Wed, 2009-09-02 at 16:16 +0200, Bart Geesink wrote: > [snip] Apparently, adding Is > there a workaround for this so I can replicate the system table > pg_largeobjects as well?
As far as I know there's no way to replicate the large objects via slony, as you can't create triggers on system tables, and slony needs one on each replicated table to intercept the data changes. For exactly this reason we abandoned the use of large objects and replaced it with a custom table, similar with pg_largeobject, and some custom code to simulate on the client side what postgres is doing when you work with the large objects. It was in fact surprisingly little code needed to do it... and we can now replicate our "large objects" via slony. Cheers, Csaba. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
