On Fri, Mar 19, 2004 at 02:01:40 +0000,
Jon Jensen <[EMAIL PROTECTED]> wrote:
>
> 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.
You can treat domain socket and internet socket connections differently.
This is still a kludge but might solve your particular problem.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly