Re: can only connect to localhost is postgresql - Mailing list pgsql-novice

From Reshat Sabiq
Subject Re: can only connect to localhost is postgresql
Date
Msg-id 000001c2ca72$877b1c30$3a82d380@main
Whole thread Raw
In response to Re: can only connect to localhost is postgresql  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
> I have a question:
> Is it a legit thing to have 2 connection modes for the same host:
>
> local        all                                           ident
sameuser
> local        all                                           ident
newmode

This won't work as all connections that would match the second rule,
match the first rule, so the second rule will never be used.
In 7.3 you can write authentication rules that match connection method,
database and user, which might allow you to do what you want.

---------------
Thanks,

I wasn't aware that 7.3.1 also has better authentication support. At
home at have it, but for the site. 7.3 appears to be a significant step
forward.

It appears that an equivalent of the 2 lines above will work just fine
in 7.3. I'll try to test that next week.

Sincerely,
r.


pgsql-novice by date:

Previous
From: Andres Ledesma
Date:
Subject: Re: where is libpq.so
Next
From: "Jay G. Scott"
Date:
Subject: I can't get results inside a C program.