| From: | Marc Gehling <m(dot)gehling(at)saphirarcus(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump error |
| Date: | 2000-07-28 10:03:32 |
| Message-ID: | 39815A73.7E68104E@saphirarcus.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
Can someone post me the relation from pg_user .
Tom Lane wrote:
> Marc Gehling <m(dot)gehling(at)saphirarcus(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | brianb-pggeneral | 2000-07-28 10:11:06 | Re: Backup/dump of huge tables and performance |
| Previous Message | Karl Trygve Kalleberg | 2000-07-28 09:54:35 | Async unidirectional replication |