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

From Tom Lane
Subject Re: Re: Still getting problems with -cache lookup for userid 26 failed- (PART 2)
Date
Msg-id 23036.992965724@sss.pgh.pa.us
Whole thread Raw
In response to Re: Still getting problems with -cache lookup for userid 26 failed- (PART 2)  ("Vilson farias" <vilson.farias@digitro.com.br>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Pete Leonard
Date:
Subject: Re: rule on insert with default values for new instance
Next
From: Vivek Khera
Date:
Subject: Re: MySQL Question