IDENT and pg_hda.conf - Mailing list pgsql-general

From Susemail
Subject IDENT and pg_hda.conf
Date
Msg-id 200401292339.23255.susemail@hawaii.rr.com
Whole thread Raw
Responses Re: IDENT and pg_hda.conf  (Paul Thomas <paul@tmsl.demon.co.uk>)
Re: IDENT and pg_hda.conf  (Bruno Wolff III <bruno@wolff.to>)
List 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


pgsql-general by date:

Previous
From: Susemail
Date:
Subject: No Database Drivers
Next
From: "NTPT"
Date:
Subject: Re: Specifying many rows in a table