pg_dump error
Hello,
with pg_dump testdb > db.out there is an errorline
getTypes(): SELECT failed. Explanation from backend: 'ERROR: cache
lookup for
userid 201 failed
any Idea
marc
Hello,
when i read the pg_user, the same error comes ( 6.5.3 Postgresdb)
tipdb=> select * from pg_user;
ERROR: cache lookup for userid 201 failed
Marc Gehling wrote:
Show quoted text
Hello,
with pg_dump testdb > db.out there is an errorline
getTypes(): SELECT failed. Explanation from backend: 'ERROR: cache
lookup for
userid 201 failedany Idea
marc
Marc Gehling <m.gehling@saphirarcus.de> writes:
when i read the pg_user, the same error comes ( 6.5.3 Postgresdb)
tipdb=> select * from pg_user;
ERROR: cache lookup for userid 201 failed
Hm. It sorta looks like you deleted the pg_shadow entry for the
Postgres superuser. That was not a good idea :-(. You may be
able to recover by re-adding an entry with the same userid.
regards, tom lane
Hello,
Can someone post me the relation from pg_user .
Tom Lane wrote:
Show quoted text
Marc Gehling <m.gehling@saphirarcus.de> writes:
when i read the pg_user, the same error comes ( 6.5.3 Postgresdb)
tipdb=> select * from pg_user;
ERROR: cache lookup for userid 201 failedHm. It sorta looks like you deleted the pg_shadow entry for the
Postgres superuser. That was not a good idea :-(. You may be
able to recover by re-adding an entry with the same userid.regards, tom lane