On 13-04-16 11:18 AM, Vick Khera wrote: > > On Tue, Apr 16, 2013 at 9:10 AM, Vick Khera <[email protected] > <mailto:[email protected]>> wrote: > > So my instinct is that there is some change in 9.2 that slony is > tripping over that is causing it to lock something for way too long. > I would appreciate any guidance on figuring out what that is, so I > can avoid having long delays in my replication while vacuum is running. > > > Hmmm... I just realized that there is a pg_dump that starts at about > 3am. I wonder of that's the cause, and not slony/vacuum interaction > after all. I will experiment by changing the time of the vacuum tonight. >
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. > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
