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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to