Re: nested xacts: update password file

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: nested xacts: update password file
Date: 2004-07-12 19:19:43
Message-ID: 200407121919.i6CJJiU02528@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Alvaro Herrera wrote:
> On Mon, Jul 12, 2004 at 02:31:37PM -0400, Bruce Momjian wrote:
>
> > OK, but why would we document the contents of a file that are not to be
> > modified by the user?
>
> But how is the file used? Where do I put the file, what do I put in
> pg_hba.conf to use the file? Can I have several files, one per
> pg_hba.conf entry? Can I use multiple files with a single pg_hba.conf
> entry? What happens if I have a username that has the separator in it?

We no longer have the capability for external password files, which is
what the 7.2 docs were talking about. We removed it when we went to
encrypted MD5 password and pg_hba.conf entries where you can reference
external lists of users and groups.

The file you were touching is a cache of usernames written by backends
modifing the pg_shadow table and read by the postmaster.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-12 19:26:58 More canonicalization fixes
Previous Message Alvaro Herrera 2004-07-12 19:06:03 Re: nested xacts: update password file