Re: Still getting problems with -cache lookup for userid 26 failed- (PART 2) - Mailing list pgsql-general

Sorry, I do have a pg_shadow file, but it's empty.

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? I couldn't find info about this file in html docs. I have another postgre installed here and in
thatmachine (working very well) pg_pwd is empty. 

Regards.

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>