<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><head><!--[if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]--></head><body><div class="ydp58007262yahoo-style-wrap" style="font-family: Helvetica Neue, Helvetica, Arial, sans-serif; font-size: 13px;"><div id="ydp58007262yiv4628413488"><div><div class="ydp58007262yiv4628413488yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div class="ydp58007262yiv4628413488ydp7f474124yahoo_quoted" id="ydp58007262yiv4628413488ydp7f474124yahoo_quoted_0669218940">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
</div></div></div></div></div></div><div class="ydp3498c644yiv4628413488yqt4535281645" id="ydp3498c644yiv4628413488yqtfd86512"><div>> On Thursday, 13 June 2019, 18:11:34 BST, Christopher Browne <cbbrowne@gmail.com> wrote:
</div>
<div><div id="ydp3498c644yiv4628413488ydp7f474124yiv0588128369"><div><div dir="ltr"><div class="ydp3498c644yiv4628413488ydp7f474124yiv0588128369yqt9737824467" id="ydp3498c644yiv4628413488ydp7f474124yiv0588128369yqtfd75116"><div dir="ltr">On Thu, 13 Jun 2019 at 12:48, Tory M Blue <<a shape="rect" href="mailto:tmblue@gmail.com" rel="nofollow" target="_blank">tmblue@gmail.com</a>> wrote:<br clear="none"></div></div><div class="ydp3498c644yiv4628413488ydp7f474124yiv0588128369gmail_quote"><div class="ydp3498c644yiv4628413488ydp7f474124yiv0588128369yqt9737824467" id="ydp3498c644yiv4628413488ydp7f474124yiv0588128369yqtfd96614"><blockquote class="ydp3498c644yiv4628413488ydp7f474124yiv0588128369gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex;"><div dir="ltr"><div class="ydp3498c644yiv4628413488ydp7f474124yiv0588128369gmail_quote"><div>I saw nothing in the locks when I looked. We did notice that in our second dump, while we are using a -n table, we are not including a -N _slonschema,. Now that should work!! but we are going to add the -N _slonschema as well as the -n table, just to see. Will poke it some more this eve!</div></div></div></blockquote></div><div>><br clear="none"></div><div>> The relevant documentation is thus... <br clear="none"></div><div><a shape="rect" href="http://slony.info/documentation/2.2/appendix.html#AEN9598" rel="nofollow" target="_blank">> http://slony.info/documentation/2.2/appendix.html#AEN9598</a></div><div>><br clear="none"></div><div>> It's a bit dated; at the time that was written, pg_dump did not yet have the --exclude-schema option :-)</div><div>><br clear="none"></div><div>> I think that's the "smoking gun", there! Yes indeed, add -N _slonschema, that should help!<div class="ydp3498c644yiv4628413488ydp7f474124yiv0588128369yqt9737824467" id="ydp3498c644yiv4628413488ydp7f474124yiv0588128369yqtfd54592"><br clear="none"></div></div></div></div></div></div><div class="ydp3498c644yiv4628413488ydp7f474124yqt9737824467">Late to the party, but this is the exact behaviour when the slony schema isn't excluded in 2.0 onwards, my analysis of when this hit us after an upgrade from 1.2.x is here:</div><div class="ydp3498c644yiv4628413488ydp7f474124yqt9737824467"><br></div><div class="ydp3498c644yiv4628413488ydp7f474124yqt9737824467"><a href="https://www.mail-archive.com/slony1-general@lists.slony.info/msg06067.html" rel="nofollow" target="_blank" class="enhancr_card_1042189914">[Slony1-general] pg_dump and replication lag in 2.0.7</a></div><div><br></div><div id="ydpb08a3dfcenhancr_card_1042189914" class="ydpb08a3dfcyahoo-link-enhancr-card ydpb08a3dfcymail-preserve-class ydpb08a3dfcymail-preserve-style" style="max-width:400px;font-family:Helvetica Neue, Segoe UI, Helvetica, Arial, sans-serif" data-url="https://www.mail-archive.com/slony1-general@lists.slony.info/msg06067.html" data-type="YENHANCER" data-size="MEDIUM" contenteditable="false"><a href="https://www.mail-archive.com/slony1-general@lists.slony.info/msg06067.html" style="text-decoration:none !important;color:#000 !important" class="ydpb08a3dfcyahoo-enhancr-cardlink" rel="nofollow" target="_blank"><table class="ydpb08a3dfccard-wrapper ydpb08a3dfcyahoo-ignore-table" style="max-width:400px" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td width="400"><table class="ydpb08a3dfccard ydpb08a3dfcyahoo-ignore-table" style="max-width:400px;border-width:1px;border-style:solid;border-color:rgb(224, 228, 233);border-radius:2px" width="100%" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td class="ydpb08a3dfccard-primary-image-cell" style="background-color: rgb(0, 0, 0); background-repeat: no-repeat; background-size: cover; position: relative; border-radius: 2px 2px 0px 0px; min-height: 175px;" valign="top" height="175" bgcolor="#000000" background="https://s.yimg.com/lo/api/res/1.2/S3dS6SXkBJpUOnPBCo7RFQ--~A/Zmk9ZmlsbDt3PTQwMDtoPTIwMDthcHBpZD1pZXh0cmFjdA--/https://www.mail-archive.com/logo.png.cf.jpg"><!--[if gte mso 9]><v:rect fill="true" stroke="false" style="width:396px;height:175px;position:absolute;top:0;left:0;"><v:fill type="frame" color="#000000" src="https://s.yimg.com/lo/api/res/1.2/S3dS6SXkBJpUOnPBCo7RFQ--~A/Zmk9ZmlsbDt3PTQwMDtoPTIwMDthcHBpZD1pZXh0cmFjdA--/https://www.mail-archive.com/logo.png.cf.jpg"/></v:rect><![endif]--><table class="ydpb08a3dfccard-overlay-container-table ydpb08a3dfcyahoo-ignore-table" style="width:100%" cellspacing="0" cellpadding="0" border="0"><tbody><tr><td class="ydpb08a3dfccard-overlay-cell" style="background-color: transparent; border-radius: 2px 2px 0px 0px; min-height: 175px;" valign="top" bgcolor="transparent" background="https://s.yimg.com/cv/ae/nq/storm/assets/enhancrV21/1/enhancr_gradient-400x175.png"><!--[if gte mso 9]><v:rect fill="true" stroke="false" style="width:396px;height:175px;position:absolute;top:-18px;left:0;"><v:fill type="pattern" color="#000000" src="https://s.yimg.com/cv/ae/nq/storm/assets/enhancrV21/1/enhancr_gradient-400x175.png"/><v:textbox inset="0,0,20px,0"><![endif]--><table class="ydpb08a3dfcyahoo-ignore-table" style="width: 100%; min-height: 175px;" height="175" border="0"><tbody><tr><td class="ydpb08a3dfccard-richInfo2" style="text-align:left;padding:15px 0 0 15px;vertical-align:top"></td><td class="ydpb08a3dfccard-actions" style="text-align:right;padding:15px 15px 0 0;vertical-align:top"><div class="ydpb08a3dfccard-share-container"></div></td></tr></tbody></table><!--[if gte mso 9]></v:textbox></v:rect><![endif]--></td></tr></tbody></table></td></tr><tr><td><table class="ydpb08a3dfccard-info ydpb08a3dfcyahoo-ignore-table" style="background-color: rgb(255, 255, 255); background-repeat: repeat; background-attachment: scroll; background-image: none; background-size: auto; position: relative; z-index: 2; width: 100%; max-width: 400px; border-radius: 0px 0px 2px 2px; border-top: 1px solid rgb(224, 228, 233);" cellspacing="0" cellpadding="0" border="0" align="center"><tbody><tr><td style="background-color:#ffffff;padding:16px 0 16px 12px;vertical-align:top;border-radius:0 0 0 2px"></td><td style="vertical-align:middle;padding:12px 24px 16px 12px;width:99%;font-family:Helvetica Neue, Segoe UI, Helvetica, Arial, sans-serif;border-radius:0 0 2px 0"><h2 class="ydpb08a3dfccard-title" style="font-size: 14px; line-height: 19px; margin: 0px 0px 6px; font-family: Helvetica Neue, Segoe UI, Helvetica, Arial, sans-serif; color: rgb(38, 40, 42);">[Slony1-general] pg_dump and replication lag in 2.0.7</h2><p class="ydpb08a3dfccard-description" style="font-size: 12px; line-height: 16px; margin: 0px; color: rgb(151, 155, 167);"></p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></a></div><div><br></div><div><br></div></div>
</div><div class="ydp3498c644yiv4628413488yqt4535281645" id="ydp3498c644yiv4628413488yqtfd42713">
</div></body></html>