Still getting problems with -cache lookup for userid 26 failed- - Mailing list pgsql-general
| From | Vilson farias |
|---|---|
| Subject | Still getting problems with -cache lookup for userid 26 failed- |
| Date | |
| Msg-id | 007501c0f8c5$b4013e40$98a0a8c0@dti.digitro.com.br Whole thread Raw |
| In response to | ERROR: cache lookup for userid 26 failed ("Vilson farias" <vilson.farias@digitro.com.br>) |
| Responses |
Re: Still getting problems with -cache lookup for userid 26 failed-
|
| List | pgsql-general |
How do you mean, Tom?
> "Vilson farias" <vilson.farias@digitro.com.br> writes:
> > Does anyone know what is this error?
> > ERROR: cache lookup for userid 26 failed
>
> Evidently pg_shadow has no entry with usesysid 26. Add it back...
>
> regards, tom lane
>
I dont have a pg_shadow file, I use a passwd file instead. Inside passwd there is only one line :
postgres:LtOj6bwu7TF7k
My pg_hba.conf :
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 192.168.160.0 255.255.255.0 password passwd
host all 192.168.162.0 255.255.255.0 password passwd
My /etc/passwd :
postgres:x:26:26:PostgreSQL Server:/home/postgres:/bin/bash
My /etc/group
postgres:x:26:
And if this is a passwd (pg_shadow) error, why can I access some tables and other not?
persona=> select * from pg_class
persona-> ;
relname | reltype | relowner | relam | relpages | reltuples | rell
ongrelid | relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | reluk
eys | relfkeys | relrefs | relhaspkey | relhasrules | relacl
---------------------------------+---------+----------+-------+----------+-----------+-----
---------+-------------+-------------+---------+----------+-----------+-------------+------
----+----------+---------+------------+-------------+--------
pg_type | 71 | 26 | 0 | 2 | 122 |
0 | t | f | r | 16 | 0 | 0 |
0 | 0 | 0 | f | f |
pg_attribute | 75 | 26 | 0 | 6 | 461 |
0 | t | f | r | 15 | 0 | 0 |
0 | 0 | 0 | f | f |
pg_proc | 81 | 26 | 0 | 26 | 1083 |
0 | t | f | r | 16 | 0 | 0 |
0 | 0 | 0 | f | f |
tele_fidel_hierarq | 0 | 26 | 0 | 176 | 6592 |
0 | t | f | r | 7 | 0 | 1 |
0 | 0 | 0 | f | f |
tipo_atendimento | 0 | 26 | 0 | 10 | 1000 |
0 | t | f | r | 3 | 0 | 2 |
0 | 0 | 0 | f | f |
(69 rows)
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: Segunda-feira, 18 de Junho de 2001 16:57
Subject: Re: [GENERAL] ERROR: cache lookup for userid 26 failed
pgsql-general by date: