Cache lookup problems dont go away

Greetings again,

  I'm still getting problems, could you give me some more info about how can I change pg_shadow? I tried lots of ways
andnothing works, because it seens to be unaccessible. 

 persona=> insert into pg_shadow values('postgres', 26, 't', 't', 't', 't', '', NULL);
 ERROR:  pg_shadow: Permission denied.

 persona=> select * from pg_shadow;
 ERROR:  pg_shadow: Permission denied.

 persona=> select * from pg_user;
 ERROR:  cache lookup for userid 26 failed

 persona=> alter user postgres CREATEUSER;
 ERROR:  ALTER USER: permission denied


 After all that errors, I killed postmaster and started a single postgres process, with -O activated and still nothing.

 [postgres@bxsgalena postgres]$  postgres -d $PGDATA -O persona
 010619.15:47:26.088     [0] DEBUG:  Data Base System is starting up at Tue Jun 19 15:47:26 2001
 010619.15:47:26.088     [0] DEBUG:  Data Base System was interrupted being in production at Tue Jun 19 5:46:46 2001
 010619.15:47:26.110     [0] DEBUG:  Data Base System is in production state at Tue Jun 19 15:47:26 2001
 > POSTGRES backend interactive interface
 $Revision: 1.155.2.1 $ $Date: 2000/08/30 21:19:32 $

 backend> select * from pg_shadow
 010619.15:47:42.213     [0] ERROR:  pg_shadow: Permission denied.
 010619.15:47:42.213     [0] ERROR:  pg_shadow: Permission denied.
 backend>

 Regards,

 José Vilson de Mello de Farias
 Dígitro Tecnologia Ltda - Brazil

> ----- Original Message -----
> From: Tom Lane <tgl@sss.pgh.pa.us>
> To: Vilson farias <vilson.farias@digitro.com.br>
> Cc: <pgsql-general@postgresql.org>
> Sent: Terça-feira, 19 de Junho de 2001 12:48
> Subject: Re: [GENERAL] Re: Still getting problems with -cache lookup for userid 26 failed- (PART 2)
>
>
> > "Vilson farias" <vilson.farias@digitro.com.br> writes:
> > > I have a pg_pwd too with this text inside :
> > > [postgres@bxsgalena data]$ cat pg_pwd
> > > postgres        0       x       x       x       x       1       \N
> >
> > > What is it used for?
> >
> > pg_pwd is a plain-ASCII dump of the pg_shadow table.  It's used by the
> > postmaster (since the postmaster can't read database tables by itself).
> > AFAIR it's only used if you specify password auth based on the pg_shadow
> > password.
> >
> > However, you need to have pg_shadow entries for all your PG users
> > regardless of what your connection authorization setup may be.
> > relowner and so forth are supposed to be references to pg_shadow rows.
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>