From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Jon Jensen <jon(at)endpoint(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Authentication drop-down? |
Date: | 2004-03-19 07:47:14 |
Message-ID: | 200403190747.14825.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Friday 19 March 2004 02:01, Jon Jensen wrote:
> On Thu, 18 Mar 2004, Bruno Wolff III wrote:
> > On Thu, Mar 18, 2004 at 22:58:46 +0000, Jon Jensen <jon(at)endpoint(dot)com>
wrote:
> > > Is there some other way to do what I'm looking for here without the
> > > authentication method fallthrough Josh proposes?
> >
> > Assuming people aren't sharing accounts, you could let any authorized
> > postgres user connect using ident authentication as postgres. This
> > should be usable any place you are willing to let the postgres user
> > authenticate using ident.
>
> That's true, but that doesn't satisfy the need. I want an automated
> process running as OS user "postgres" to authenticate with ident, but I'd
> also like to be able have, say, phpPgAdmin (running as user "apache")
> connect as Pg user "postgres" via the UNIX socket using an MD5 password.
> There's currently no way to do both AFAICT. I can create another superuser
> with a different name so each user has different pg_hba settings, but
> that's about it.
How about a .pgpass file for OS-user postgres, and just set all logins for
PG-user postgres to use password?
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2004-03-19 09:39:00 | Re: COPY formatting |
Previous Message | Tom Lane | 2004-03-19 07:16:01 | Re: Authentication drop-down? |