Hi,
last night I tried to reindex my database with some really ugly results.
I can no longer use the database.
backend> REINDEX DATABASE "CLIX1"
NOTICE: relation 16416 was reindexed
NOTICE: relation 1255 was reindexed
NOTICE: relation 16410 was reindexed
NOTICE: relation 1247 was reindexed
NOTICE: relation 1249 was reindexed
NOTICE: relation 1259 was reindexed
NOTICE: relation 16388 was reindexed
NOTICE: relation 16390 was reindexed
NOTICE: relation 16392 was reindexed
NOTICE: relation 16394 was reindexed
NOTICE: relation 16396 was reindexed
NOTICE: relation 16398 was reindexed
NOTICE: relation 16400 was reindexed
NOTICE: relation 16402 was reindexed
NOTICE: relation 16404 was reindexed
NOTICE: relation 16406 was reindexed
NOTICE: relation 16412 was reindexed
NOTICE: relation 16418 was reindexed
NOTICE: relation 16594 was reindexed
NOTICE: relation 16596 was reindexed
NOTICE: relation 16598 was reindexed
NOTICE: relation 16384 was reindexed
NOTICE: relation 16386 was reindexed
ERROR: Cannot create unique index. Table contains non-unique values
backend>
Which relation is that? How can I find that relation?
When I try to use the database this error shows up:
-bash-2.05b$ postgres -D /var/lib/pgsql/data/ -O -P CLIX1
LOG: database system was shut down at 2004-08-15 23:04:53 CEST
LOG: checkpoint record is at 11C/19619E54
LOG: redo record is at 11C/19619E54; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 51038367; next oid: 128363530
LOG: database system is ready
POSTGRES backend interactive interface
$Revision: 1.307.2.1 $ $Date: 2003/01/01 21:57:18 $
backend> vacuum full analyze verbose
WARNING: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (278) IS NOT
THE SAME AS HEAP' (281).
Recreate the index.
WARNING: Index pg_class_relname_nsp_index: NUMBER OF INDEX' TUPLES
(278) IS NOT THE SAME AS HEAP' (281).
Recreate the index.
ERROR: _mdfd_getrelnfd: cannot open relation
pg_statistic_relid_att_index: No such file or directory
backend>
TIA
Ulrich