<div dir="ltr"><br><div class="gmail_extra"><br clear="all"><div>Dave Cramer</div>
<br><div class="gmail_quote">On 16 October 2014 11:48, Glyn Astill <span dir="ltr"><<a href="mailto:glynastill@yahoo.co.uk" target="_blank">glynastill@yahoo.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> From: Glyn Astill <<a href="mailto:glynastill@yahoo.co.uk">glynastill@yahoo.co.uk</a>><br>
<br>
> To: Dave Cramer <<a href="mailto:davecramer@gmail.com">davecramer@gmail.com</a>><br>
> Cc: slony <<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>><br>
> Sent: Thursday, 16 October 2014, 16:26<br>
<span class="">> Subject: Re: [Slony1-general] Lag time increasing but there are no events<br>
><br>
><br>
>> From: Dave Cramer <<a href="mailto:davecramer@gmail.com">davecramer@gmail.com</a>><br>
>> To: Glyn Astill <<a href="mailto:glynastill@yahoo.co.uk">glynastill@yahoo.co.uk</a>><br>
>> Cc: slony <<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>><br>
>> Sent: Thursday, 16 October 2014, 15:41<br>
>> Subject: Re: [Slony1-general] Lag time increasing but there are no events<br>
>><br>
>><br>
>><br>
>> Actually I think it is because a pg_dump of the db is going on.<br>
>><br>
>><br>
>> Can you dump a slave ?<br>
>><br>
>><br>
>> Do you have to exclude the slony clusters (which would make sense)?<br>
><br>
><br>
> Yeah from past experience the locks taken by pg_dump cause replication to lag. I<br>
> normally use the -N switch in pg_dump to exclude the schema. For pg_restore I<br>
> usually create a TOC with the -l option and pipe it to grep to filter out the<br>
> references to the slony schema that get dumped for the triggers, and then -L<br>
> option to use it with my restore.<br>
<br>
</span>Also I assumed you were using 2.0+ there, with 1.2 there's some slight fiddling done in pg_catalog to disable triggers, from memory pg_trigger.tgrelid is pointed to an index rather than the table or something like that. I used to dump out with the slony schema, and run uninstallnode() and drop schema cascade against the restored database.<br>
</blockquote></div><br></div><div class="gmail_extra"><br></div><div class="gmail_extra">Yes I am using 2.0+ Thanks</div></div>