Re: Cannot connect though socket

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Cannot connect though socket
Дата
Msg-id 9274.1154922295@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Cannot connect though socket  ("Vinicius Carvalho" <java.vinicius@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Cannot connect though socket
Следующее
От: "Dylan Fogarty-MacDonald"
Дата:
Сообщение: Scheduling data input from tab delimited file via php