Thread: 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:

> 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

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:

> 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