On 13-04-16 11:18 AM, Vick Khera wrote:
>
> On Tue, Apr 16, 2013 at 9:10 AM, Vick Khera <vivek at khera.org
> <mailto:vivek at khera.org>> 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
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>