Greetings,
I am trying to setup postgres and postfix using webmin. I am
following this guide:
http://gentoo-wiki.com/HOWTO_Email:_A_Complete_Virtual_System_-_Postfix_to_Postgres
I received the following in the postgres db section of webmin:
select * from pg_database order by datname failed : no pg_hba.conf
entry for host "[local]", user "postgres", database "template1", SSL
off
I sadly have no clue on how to go by fixing this. Please help :) It
talks about this error in the guide. But it really does not tell you
how to fix it specifically. I don't even see a section in the area
specified for the authentication they are suggesting.
Operating system Gentoo Linux
Webmin version 1.350
I believe the problem is in this section.
# "local" is for Unix domain socket connections only
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database
# super user can access the database using some other method.
# Noninteractive
# access to all databases is required during automatic maintenance
# (autovacuum, daily cronjob, replication, and similar tasks).
#
# Database administrative login by UNIX sockets
local all postgres ident sameuser
host all all 10.2.0.202 255.255.255.255 trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust
I could be wrong. Please help the newb.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
--
William Leite Araújo
Estudante de paternidade - 13a semana
