From: | "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Re: Still getting problems with -cache lookup for userid 26 failed- (PART 2) |
Date: | 2001-06-19 18:51:50 |
Message-ID: | 007701c0f8f0$e7149860$98a0a8c0@dti.digitro.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings again,
I'm still getting problems, could you give me some more info about how can I change pg_shadow?
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(at)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 15: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(at)sss(dot)pgh(dot)pa(dot)us>
To: Vilson farias <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)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(dot)farias(at)digitro(dot)com(dot)br> writes:
> > I have a pg_pwd too with this text inside :
> > [postgres(at)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2001-06-19 19:05:50 | Re: Embedded sql PREPARE statement |
Previous Message | Bryan White | 2001-06-19 18:23:33 | Re: Postmaster loses bash shell command prompt? |