<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div>Hi Guys,</div><div><br></div><div>Since we were on slony 1.2 I've been doing full pg_dumps from our servers, and restoring them onto a test setup daily.</div><div><br></div><div>Since we've moved to 2.0 I've noticed that those full dumps now cause the subscribers to lag. I just wanted to ask - is this expected behaviour in 2.0? And is the only real workaround skipping the schema during pg_dump?</div><div><br></div><div> It <span id="misspell-1" class=""><span>appears</span></span> to me that <span id="misspell-2" class=""><span id="misspell-1" class="mark">cleanupEvent</span></span>() is waiting for exclusive access to something in the slony schema. An uneducated guess is that it's going to be that <span id="misspell-4" class=""><span id="misspell-3" class="mark">cleanupEvent</span></span>() is
calling <span id="misspell-5" class=""><span id="misspell-4" class="mark">logswitch</span></span>_start() or <span id="misspell-6" class=""><span id="misspell-5" class="mark">logswitch</span></span>_finish() and they are trying to lock <span id="misspell-7" class=""><span id="misspell-6" class="mark">sl</span></span>_<span id="misspell-8" class=""><span id="misspell-7" class="mark">config</span></span>_lock which is blocking. In turn <span id="misspell-9" class=""><span id="misspell-8" class="mark">cleanupEvent</span></span>() can't commit some other update it's done causing <span id="misspell-10" class=""><span id="misspell-9" class="mark">createEvent</span></span>() to block also?<br></div><div><br></div><div>Am I wrong in thinking <span id="misspell-11" class=""><span id="misspell-10" class="mark">cleanupEvent</span></span>() didn't used to kick off the <span id="misspell-12" class=""><span id="misspell-11" class="mark">logswitching</span></span> in
1.2? And am I oversimplifying things by saying why can't the <span id="misspell-13" class=""><span id="misspell-12" class="mark">logswitch</span></span> functions just add <span id="misspell-14" class=""><span id="misspell-13" class="mark">NOWAIT</span></span> when trying to lock <span id="misspell-15" class=""><span id="misspell-14" class="mark">sl</span></span>_<span id="misspell-16" class=""><span id="misspell-15" class="mark">config</span></span>_lock, and skip it <span id="misspell-17" class=""><span>if an</span></span> exception is raised? Or am I just totally wrong?<br></div><div><br></div><div><br></div><div>Thanks</div><div>Glyn</div></div></body></html>