Re: login error - Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "kamik"

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