so should _slony.sl_table.tab_reloid match pg_catalog.pg_class.relfilenode for each table in a replication set?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan Sent: Thursday, October 02, 2008 10:35 AM To: [email protected] 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 [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
