Jan Wieck JanWieck at Yahoo.com
Tue Sep 2 08:25:16 PDT 2008
On 9/2/2008 5:59 AM, René-Etienne Muscat wrote:
> Today I tried the *UNINSTALL NODE* on the server, but it was unsuccessful!
> It returned:
> PGRES_FATAL_ERROR select "_test_cluster".uninstallNode();  - ERROR:  
> Slony-I: alterTableRestore(): Table with id 300 not found
> 
> Should I go to the *drop schema <cluster name> cascade;* or is there 
> another slonik command I can use?

You apparently dropped that table without going through EXECUTE SCRIPT. 
Therefore, the information Slony has about what it did to the schema is 
not in sync with your current schema any more.

What you should do is remove the entry FOR THAT ONE TABLE from sl_table 
and then try the UNINSTALL NODE again.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin



More information about the Slony1-general mailing list