Re: IDENT and pg_hda.conf

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Susemail <susemail(at)hawaii(dot)rr(dot)com>
Cc: pgsql-general(at)PostgreSQL(dot)org
Subject: Re: IDENT and pg_hda.conf
Date: 2004-01-30 16:15:55
Message-ID: 20040130161555.GB12848@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 29, 2004 at 23:39:23 -1000,
Susemail <susemail(at)hawaii(dot)rr(dot)com> wrote:
> Is this good advice?
>
> IDENT Authentication failed for user "postgres"
>
> This error has everything to do with the way distros set up access rights for
> postgres. They are way too restrictive and leave you wondering what to do
> next.
>
> Do yourself a favour and change authentication type in pg_hba.conf to
>
> local all trust
>
> until you have figured out what all this stuff in pg_hba.conf does. Read about
> the different authentication settings and change them as you see fit. It is
> all described in detail in pg_hba.conf

If only trusted users have access to the server, this is a reasonable way
to start off while learning things. Generally using ident for local access
is the way to go unless you are using OS where it doesn't work.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2004-01-30 17:38:51 Re: Pl/tcl auto-load problem
Previous Message Bruno Wolff III 2004-01-30 16:05:24 Re: I can't upgrade to PostgreSQL 7.4 in RedHat 9.0