Sun Jul 13 07:59:20 PDT 2008
- Previous message: [Slony1-general] [SLONY] Fail-over
- Next message: [Slony1-general] ERROR: Slony-I: alterTableRestore(): Table with id 54 not found
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] [SLONY] Fail-over
- Next message: [Slony1-general] ERROR: Slony-I: alterTableRestore(): Table with id 54 not found
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list