To close this out for the list, this did solve my issue. No replication delays were reported when the dump was told to skip the slony schema.
On Tue, Apr 16, 2013 at 12:06 PM, Vick Khera <[email protected]> wrote: > > On Tue, Apr 16, 2013 at 11:35 AM, Steve Singer <[email protected]>wrote: > >> Slony takes needs an exclusive lock on sl_event to create SYNC events. If >> your pg_dump includes the slony schema then you should expect replication >> to pause. A lot of people exclude the slony schema from their pg_dumps for >> this reason. >> > > Good idea. Seems contrary to the purpose of these particular backups to > even need the slony schema. Thanks for the tip! > >
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
