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 that machine (working very well) pg_pwd is empty.
Regards.
> How do you mean, Tom?
>
> > "Vilson farias" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> To: Vilson farias <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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 [EMAIL PROTECTED]
>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl