Re: Cannot connect though socket - Mailing list pgsql-novice

From Tom Lane
Subject Re: Cannot connect though socket
Date
Msg-id 9274.1154922295@sss.pgh.pa.us
Whole thread Raw
In response to Cannot connect though socket  ("Vinicius Carvalho" <java.vinicius@gmail.com>)
List pgsql-novice
"Vinicius Carvalho" <java.vinicius@gmail.com> writes:
> Well, here's my pg_hba.conf

> # IPv4 local connections:
> host    all         all         0.0.0.0 0.0.0.0          password
> host    all         all         127.0.0.1/32          trust

In that configuration, the second line is a no-op, because the first one
will soak up every incoming IPv4 connection and force it to do password
authentication.  pg_hba.conf lines are order-sensitive --- the usual
rule is to put the more restrictive pattern first.

> Both java and pgadmin interfaces complain about: Postgres: FATAL:
> password authentication failed for user "vinicius"

Either you didn't create a database user named "vinicius", or you didn't
give it a password, or you're supplying the wrong password from the
client side ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Cannot connect though socket
Next
From: "Dylan Fogarty-MacDonald"
Date:
Subject: Scheduling data input from tab delimited file via php