Re: Failure upgrading PG 9.2 to 9.3

Sam Saffron <sam.saffron@gmail.com> writes:
> Why would
> "ERROR:  operator does not exist: name !~ unknown"
> Come up ?

It's hard to explain that as anything except corrupted system catalogs
in your existing database :-(.  If you were really lucky, reindexing
pg_operator would fix it; but since pg_operator is usually pretty static,
it seems unlikely that it suffered index corruption.

> Any way to work around this?

Rather than relying on pg_upgrade, you could try using pg_dump(all)
to extract the data.  With some luck, pg_dump wouldn't be affected by
whatever has happened to the pg_operator catalog.

            regards, tom lane