Re: authentication problems
От | Tom Lane |
---|---|
Тема | Re: authentication problems |
Дата | |
Msg-id | 799.1001822151@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: authentication problems (Russ McBride <Russ@psyex.com>) |
Ответы |
Re: authentication problems
|
Список | pgsql-admin |
Russ McBride <Russ@psyex.com> writes: > Typing "/usr/local/pgsql/bin/psql -h localhost testdb" starts up my > database in psql quite nicely, which seems to indicate to me that the > pg_hba.conf is being read and the line: > local all trust > is working as expected (I assume that this is the line that allows > all local UNIX socket connections). You assume wrong: "-h localhost" triggers a connection over IP, not over UNIX sockets. Specifically, it's going to match the pg_hba.conf line that mentions 127.0.0.1. At this point I think your problem is that your JDBC setup is trying to connect to your machine by name, not by the "localhost" alias, and this results in a connection via your current network IP address rather than the 127.0.0.1 loopback address. Since you have an entry in pg_hba.conf for 127.0.0.1 and not the other address, only the localhost address will work. regards, tom lane
В списке pgsql-admin по дате отправления: