Hi,

AFAIK you cannot dump out, then restore a schema with slony in place.

Slony uses object OIDs (as you've seen in alterTableRestore()) and even with the -o flag you cannot dump them, you can only dump the OIDs for row data, thus when you reload all your data the slony schema is junk.

The only way to do it is to drop cascade the slony schema and setup the slony cluster again by starting from scratch or adding it as a new node to an existing cluster.

Put me straight if I'm wrong here people.
Glyn



----- Original Message ----
> From: Ibrahim Harrani <ibrahim.harrani at gmail.com>
> To: slony1-general at lists.slony.info
> Sent: Sunday, 13 July, 2008 3:59:20 PM
> Subject: [Slony1-general] ERROR: Slony-I: alterTableRestore(): Table with id 54 not found
> 
> Hi,
> 
> One of my colleague restored a master pgsql database which is
> replicated with slony-1 without dumping oid.  (pg_dump is not issued
> with -o option)
> 
> So, all the table's oid (tab_reloid)  in my_cluster.st_table is wrong!
> When I tried to drop a table or uninstall the node, I get the
> following error message:
> 
> :5: PGRES_FATAL_ERROR select "_mycluster".setDropTable(54);  -
> ERROR:  Slony-I: alterTableRestore(): Table with id 54 not found
> 
> 
> Here is the some select output on master db:
> 
> cargomax=# SELECT tab_reloid  from _gokboracluster.sl_table where tab_id=54;
> tab_reloid
> ------------
>       21428
> 
> 
> cargomax=# SELECT oid FROM pg_class WHERE relname = 'mytable';
>    oid
> ---------
> 5577619
> 
> There are more than 3000 tables in the slony sl_table.  What is the
> best solution to solve this problem?
> 
> Thanks in advance
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general



      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html