Thread: Upgrade problems

I've been trying to upgrade from 6.5 to 7.0.  Red hats
upgrade scripts didn't work.  I finally ended up
reinstalling 6.5 on my machine at home and have been
trying to use pg_dumpall to dump my database to a file
which I can take to work to install on 7.0.  Enough
with the details, can anyone tell me what the
following error message means.

[pgsql]$ pg_dumpall -o > db.out
getTypes(): SELECT failed.  Explanation from backend:
'ERROR:  cache lookup for userid 100 failed
'.
pg_dump failed on vemail, exiting
[pgsql]$

Kevin



__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.com/

Kevin Stachowski <teachbiology@yahoo.com> writes:
> 'ERROR:  cache lookup for userid 100 failed

Looks like you have some object in the database that's marked as owned
by userid 100 --- and there isn't any user with userid 100 listed in
pg_shadow.  (Re)-create the user with the right ID (CREATE USER foo
WITH SYSID 100 should do it).

            regards, tom lane