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