On 2010-11-12, Jaromír Kamler <kamler@centrum.cz> wrote:
>
> Main problem is that I have bad authentication for my user. In my pg_hba.conf is this:
> # Database administrative login by UNIX sockets
> local all postgres ident
> # TYPE DATABASE USER CIDR-ADDRESS METHOD
> # "local" is for Unix domain socket connections only
> local all all trust
> # IPv4 local connections:
> host all all 127.0.0.1/32 trust
> host all all 0.0.0.0/0 md5
> hostssl all all 0.0.0.0/0 md5
> hostnossl all all 0.0.0.0/0 md5
> # IPv6 local connections:
> host all all ::1/128 md5
> When I delete in PHP script in pg_connect host="localhost", then all works fine, because I use UNIX domain socket (I
amthinging ...), but when I use "normal" connection, it is wrong. Interesting is that phppgadmin works fine ... .
>
> So, question is what I do wrong. I thing that I have mistake in pg_hba.conf, but I am blind. I have postgresql-8.4
what address is "localhost"?
I'm guessing it's not what you think it is.
--
⚂⚃ 100% natural