IDENT and pg_hda.conf

From: Susemail <susemail(at)hawaii(dot)rr(dot)com>
To: pgsql-general(at)PostgreSQL(dot)org
Subject: IDENT and pg_hda.conf
Date: 2004-01-30 09:39:23
Message-ID: 200401292339.23255.susemail@hawaii.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In any case I don't have a pg_hba.conf file:

:~> locate pg_hba.conf
/usr/share/postgresql/pg_hba.conf.sample
:~>

Should I have one? If I should, where does it belong?
Thanks,
Jerome

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Thomas 2004-01-30 11:37:35 Re: IDENT and pg_hda.conf
Previous Message Susemail 2004-01-30 05:28:47 No Database Drivers