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

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
Subject: Re: Re: Still getting problems with -cache lookup for userid 26 failed- (PART 2)
Date: 2001-06-19 15:48:44
Message-ID: 23036.992965724@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2001-06-19 15:53:57 Re: MySQL Question
Previous Message David D. Kilzer 2001-06-19 15:03:55 Re: [PATCH] Contrib C source for casting MONEY to INT[248] and FLOAT[48]