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