Wed Sep 2 07:29:47 PDT 2009
- Previous message: [Slony1-general] replicating pg_largeobjects
- Next message: [Slony1-general] where to find data transaction log?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] replicating pg_largeobjects
- Next message: [Slony1-general] where to find data transaction log?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list