From: | Jasen Betts <jasen(at)xnet(dot)co(dot)nz> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: login error - Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: password authentication failed for user "kamik" |
Date: | 2010-11-15 18:18:38 |
Message-ID: | ibrthu$707$2@reversiblemaps.ath.cx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 2010-11-12, Jaromír Kamler <kamler(at)centrum(dot)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 am thinging ...), 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
From | Date | Subject | |
---|---|---|---|
Next Message | Fred Parkinson | 2010-11-15 21:45:47 | in linux, what user do i install postgres under? |
Previous Message | Jasen Betts | 2010-11-15 18:10:24 | Re: Howto read a UTF-8 CSV with COPY? |