<div dir="ltr">I was trying to delete the unused slony replication cluster and of course, it hung up and I ended up blocking our prod db for a bit. Still coming down from that one. What would the manual removal look like (pls remember I'm not a PG dba)?<div><br></div><div>thanks</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" style="font-family:Times"><tbody><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:20px;padding-right:10px;padding-left:10px;border-right-width:1px;border-right-color:rgb(200,200,200);border-right-style:solid"><a href="http://www.clutch.com" target="_blank"><img src="https://s3.amazonaws.com/assets.clutchwallet.com/clutchLogo.png" alt="Clutch Holdings, LLC" name="UNIQUE_ID_SafeHtmlFilter_Clutch" width="140" height="76" border="0"></a></td><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:24px;border-left-width:1px;border-left-color:rgb(200,200,200);border-left-style:solid;margin-right:10px;padding-right:20px"> </td><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:18px;line-height:24px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;padding-bottom:5px"><font color="#f16528">Mike James</font> | Manager of Infrastructure<br><span style="font-size:13px">267.419.6400, ext 204 | <a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a></span></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:13px;line-height:20px;padding-top:5px">201 S Maple St. | Suite 250 | Ambler, PA 19002 <br><a href="http://www.clutch.com" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch.com</a> | <a href="https://twitter.com/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Twitter</a> | <a href="https://www.linkedin.com/company/2837209" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">LinkedIn</a> | <a href="https://www.youtube.com/user/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">YouTube</a> | <a href="http://clientsupport.clutch.com/" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch Support Center</a></td></tr></tbody></table></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:12px;font-style:italic;line-height:20px;padding-right:30px;border-top-width:1px;border-top-color:rgb(200,200,200);border-top-style:solid;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;height:30px">The only end to end consumer management platform that empowers consumer-focused businesses to identify, target, message, and engage their best customers.</td></tr></tbody></table></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Thu, May 26, 2016 at 11:17 AM, Dave Cramer <span dir="ltr"><<a href="mailto:davecramer@gmail.com" target="_blank">davecramer@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Yes, safe to drop the schema. Although I have had instances where it won't drop cleanly. In which case you will have to do it manually</div><div class="gmail_extra"><span class="HOEnZb"><font color="#888888"><br clear="all"><div><div>Dave Cramer</div></div></font></span><div><div class="h5">
<br><div class="gmail_quote">On 26 May 2016 at 11:15, Mike James <span dir="ltr"><<a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I attached to the db with pgAdmin and when I tried to open the slony replication object I got this popup message<div><br></div><div>ERROR: relation "_clients_report_orig.sl_nodelock" does not exist</div><div>LINE 1: SELECT nl_backendpid FROM _clients_report_orig.sl_nod...</div><div><br></div><div>Is it safe to go ahead and delete this unused cluster object? </div></div><div class="gmail_extra"><br clear="all"><div><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><table border="0" cellspacing="0" cellpadding="0" style="font-family:Times"><tbody><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"><table width="100%" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:20px;padding-right:10px;padding-left:10px;border-right-width:1px;border-right-color:rgb(200,200,200);border-right-style:solid"><a href="http://www.clutch.com" target="_blank"><img alt="Clutch Holdings, LLC" name="m_-3655052210268726165_m_-5168738703081999925_UNIQUE_ID_SafeHtmlFilter_Clutch" width="140" height="76" border="0"></a></td><td rowspan="2" style="font-family:'Gill Sans',Helvetica,sans-serif;line-height:24px;border-left-width:1px;border-left-color:rgb(200,200,200);border-left-style:solid;margin-right:10px;padding-right:20px"> </td><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:18px;line-height:24px;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;padding-bottom:5px"><font color="#f16528">Mike James</font> | Manager of Infrastructure<br><span style="font-size:13px"><a href="tel:267.419.6400%2C%20ext%20204" value="+12674196400" target="_blank">267.419.6400, ext 204</a> | <a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a></span></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;font-size:13px;line-height:20px;padding-top:5px">201 S Maple St. | Suite 250 | Ambler, PA 19002 <br><a href="http://www.clutch.com" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch.com</a> | <a href="https://twitter.com/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Twitter</a> | <a href="https://www.linkedin.com/company/2837209" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">LinkedIn</a> | <a href="https://www.youtube.com/user/clutchsuccess" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">YouTube</a> | <a href="http://clientsupport.clutch.com/" style="text-decoration:none;color:rgb(241,101,40)" target="_blank">Clutch Support Center</a></td></tr></tbody></table></td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:16px;height:5px"> </td></tr><tr><td style="font-family:'Gill Sans',Helvetica,sans-serif;color:rgb(71,71,71);font-size:12px;font-style:italic;line-height:20px;padding-right:30px;border-top-width:1px;border-top-color:rgb(200,200,200);border-top-style:solid;border-bottom-width:1px;border-bottom-color:rgb(200,200,200);border-bottom-style:solid;height:30px">The only end to end consumer management platform that empowers consumer-focused businesses to identify, target, message, and engage their best customers.</td></tr></tbody></table></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">On Thu, May 19, 2016 at 3:43 PM, Steve Singer <span dir="ltr"><<a href="mailto:steve@ssinger.info" target="_blank">steve@ssinger.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>On 05/19/2016 03:26 PM, Mike James wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi, Steve. I believe all of the triggers / schema were created with<br>
slony 2.2.1. Also we're currently on postgresql 9.3.5.<br>
<br>
</blockquote>
<br></span>
I think you should be able to just drop the other slony schema's with cascade and it should clean everything up.<br>
<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>
Mike<br>
<br>
Clutch Holdings, LLC <<a href="http://www.clutch.com" rel="noreferrer" target="_blank">http://www.clutch.com</a>> Mike James | Manager of<br>
Infrastructure<br>
<a href="tel:267.419.6400%2C%20ext%20204" value="+12674196400" target="_blank">267.419.6400, ext 204</a> | <a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a> <mailto:<a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a>><br>
201 S Maple St. | Suite 250 | Ambler, PA 19002<br>
Clutch.com <<a href="http://www.clutch.com" rel="noreferrer" target="_blank">http://www.clutch.com</a>> | Twitter<br>
<<a href="https://twitter.com/clutchsuccess" rel="noreferrer" target="_blank">https://twitter.com/clutchsuccess</a>> | LinkedIn<br>
<<a href="https://www.linkedin.com/company/2837209" rel="noreferrer" target="_blank">https://www.linkedin.com/company/2837209</a>> | YouTube<br>
<<a href="https://www.youtube.com/user/clutchsuccess" rel="noreferrer" target="_blank">https://www.youtube.com/user/clutchsuccess</a>> | Clutch Support Center<br>
<<a href="http://clientsupport.clutch.com/" rel="noreferrer" target="_blank">http://clientsupport.clutch.com/</a>><br>
<br>
The only end to end consumer management platform that empowers<br>
consumer-focused businesses to identify, target, message, and engage<br>
their best customers.<br>
<br>
<br></span><span>
On Thu, May 19, 2016 at 2:27 PM, Steve Singer <<a href="mailto:steve@ssinger.info" target="_blank">steve@ssinger.info</a><br></span><span>
<mailto:<a href="mailto:steve@ssinger.info" target="_blank">steve@ssinger.info</a>>> wrote:<br>
<br>
On 05/17/2016 02:59 PM, Mike James wrote:<br>
<br>
Hi, all. Due to some changes in our slony schema over the years,<br>
in our<br>
database I now see three slony schemas. Our current replication<br>
set only<br>
uses the most recent one. (slony 2.2.1 and PG 9.3)<br>
<br>
In the database when I "select * from pg_trigger; " I see some<br>
triggers<br>
from the older, unused schemas, particularly _logtrigger,<br>
_truncatetrigger have tgenabled = O.<br>
<br>
_denyaccess and _truncatedeny are disabled (tgenabled = D)<br>
<br>
How do I safely remove these triggers and delete the unused slony<br>
schemas? This maybe a simple question - but I'd rather not take the<br>
chance with the production database. Thanks,<br>
<br>
<br>
What version of slony is are the old schema's based on?<br>
Depending on the version this makes a difference on how you would<br>
remove them.<br>
<br>
Steve<br>
<br>
<br>
<br>
Mike<br>
Clutch Holdings, LLC <<a href="http://www.clutch.com" rel="noreferrer" target="_blank">http://www.clutch.com</a>> Mike<br>
James | Manager of<br>
Infrastructure<br></span>
<a href="tel:267.419.6400%2C%20ext%20204" value="+12674196400" target="_blank">267.419.6400, ext 204</a> <tel:267.419.6400%2C%20ext%20204> |<br>
<a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a> <mailto:<a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a>><br>
<mailto:<a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a> <mailto:<a href="mailto:mike.james@clutch.com" target="_blank">mike.james@clutch.com</a>>><span><br>
201 S Maple St. | Suite 250 | Ambler, PA 19002<br>
Clutch.com <<a href="http://www.clutch.com" rel="noreferrer" target="_blank">http://www.clutch.com</a>> | Twitter<br>
<<a href="https://twitter.com/clutchsuccess" rel="noreferrer" target="_blank">https://twitter.com/clutchsuccess</a>> | LinkedIn<br>
<<a href="https://www.linkedin.com/company/2837209" rel="noreferrer" target="_blank">https://www.linkedin.com/company/2837209</a>> | YouTube<br>
<<a href="https://www.youtube.com/user/clutchsuccess" rel="noreferrer" target="_blank">https://www.youtube.com/user/clutchsuccess</a>> | Clutch Support Center<br>
<<a href="http://clientsupport.clutch.com/" rel="noreferrer" target="_blank">http://clientsupport.clutch.com/</a>><br>
<br>
The only end to end consumer management platform that empowers<br>
consumer-focused businesses to identify, target, message, and engage<br>
their best customers.<br>
<br>
<br>
<br>
_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br></span>
<mailto:<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a>><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" rel="noreferrer" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><span><br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" rel="noreferrer" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br>
</span></blockquote>
<br>
</blockquote></div><br></div>
<br>_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info" target="_blank">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" rel="noreferrer" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br></blockquote></div><br></div></div></div>
</blockquote></div><br></div>