Csaba Nagy nagy at ecircle-ag.com
Wed Sep 2 07:29:47 PDT 2009
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.




More information about the Slony1-general mailing list