Re: postgres and webmin

I am sorry William but you lost me. I haven't disabled anything have I?

On 6/27/07, William Leite Araújo <william(dot)bh(at)gmail(dot)com> wrote:
> 2007/6/27, Danyelle Gragsone <ladynikon(at)gmail(dot)com>:
> > 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