Re: can only connect to localhost is postgresql

From: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>
To: "'Bruno Wolff III'" <bruno(at)wolff(dot)to>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: can only connect to localhost is postgresql
Date: 2003-02-02 04:21:15
Message-ID: 000001c2ca72$877b1c30$3a82d380@main
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message will trillich 2003-02-02 04:33:26 Re: [NOVICE] Perl - Postgres
Previous Message John Tankersley 2003-02-02 03:00:55 Setting of "D" or "PGDATA" option for data storage location