Re: postgres and webmin
От | William Leite Araújo |
---|---|
Тема | Re: postgres and webmin |
Дата | |
Msg-id | bc63ad820706270601t2bb94c93w9e4731fc26f2272f@mail.gmail.com обсуждение исходный текст |
Ответ на | postgres and webmin ("Danyelle Gragsone" <ladynikon@gmail.com>) |
Ответы |
Re: postgres and webmin
|
Список | pgsql-general |
2007/6/27, Danyelle Gragsone <ladynikon@gmail.com>:
# 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
--
William Leite Araújo
Estudante de paternidade - 13a semana
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
В списке pgsql-general по дате отправления: