On Wed, Oct 08, 2008 at 02:54:59PM -0400, Keisler Mark-QA4437 wrote:
> so should _slony.sl_table.tab_reloid match
> pg_catalog.pg_class.relfilenode for each table in a replication set? 

pg_class.oid, I think.

> 
> -----Original Message-----
> From: slony1-general-bounces at lists.slony.info
> [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Andrew
> Sullivan
> Sent: Thursday, October 02, 2008 10:35 AM
> To: slony1-general at lists.slony.info
> Subject: Re: [Slony1-general] sanity check for all tables in a set
> 
> On Tue, Sep 30, 2008 at 02:27:08PM -0500, Mark Keisler wrote:
> > Someone deleted that table at some point and now I can't move the set 
> > and I can't unsubscribe the set.  It didn't seem like I could do 
> > anything at this point besides manually strip out the cluster schema 
> > and start over.  So my first question is if there are any other 
> > options at this point?
> 
> I don't think so.  Re-educate your users not to drop things out from
> under you.  No DDL!
>  
> > Secondly, is there some sort of check that I can run periodically to 
> > make sure a set is still intact so something like this doesn't bite me
> 
> > right when I need to move a set?
> 
> You can check the _slony.sl_tables and _slony.sl_sequence tables.
> 
> A 
> 
> --
> Andrew Sullivan
> ajs at commandprompt.com
> +1 503 667 4564 x104
> http://www.commandprompt.com/
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general

-- 
Andrew Sullivan
ajs at commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/