Ibrahim Harrani ibrahim.harrani at gmail.com
Sun Jul 13 07:59:20 PDT 2008
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:

<stdin>: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


More information about the Slony1-general mailing list