Re: gp_dump: error in finding the last system oid: ERROR: get_relation_info: Relation 1262 not found

tgl@sss.pgh.pa.us (Tom Lane) wrote in message news:<7673.1044166693@sss.pgh.pa.us>...
> charette@writeme.com (Stephane Charette) writes:
> > dumping database "log"...
> > pg_dump: error in finding the last system oid: ERROR:
> > get_relation_info: Relation 1262 not found
>
> Don't tell me you did something as foolish as dropping pg_database?
> No?  Well, maybe you've got a corrupted index.  Try running a reindex on
> pg_class, or on all the system catalogs if that doesn't help.  See the
> REINDEX reference page for details on the arcane procedure to follow.

No, I did not drop pg_database.  I followed the steps to start a
standalone backend in the reference guide under "REINDEX", but it
doesn't seem to be working.  This is what I tried:

$ /usr/local/pgsql/bin/postgres -D /usr/local/stuff/data -O -P log
DEBUG:  database system was shut down at 2003-01-31 22:10:57 GMT
DEBUG:  checkpoint record is at 0/1AF664

DEBUG:  redo record is at 0/1AF664; undo record is at 0/0; shutdown
TRUE
DEBUG:  next transaction id: 196; next oid: 16632
DEBUG:  database system is ready

POSTGRES backend interactive interface
$Revision: 1.245.2.3 $ $Date: 2002/09/30 20:47:22 $

backend> reindex database log force
NOTICE:  relation 1247 was reindexed
NOTICE:  relation 1249 was reindexed
ERROR:  Cannot create unique index. Table contains non-unique values
backend>

What does this mean, and how do I fix it?

Stephane Charette
stephanecharette <nospam> AT telus <nospam> .net