Re: Pg_hba not using local setting

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Pg_hba not using local setting
Дата
Msg-id m31y19g4xn.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на Re: Pg_hba not using local setting  (James Hall <James.Hall@RadioShack.com>)
Ответы Re: Pg_hba not using local setting  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-general
James Hall <James.Hall@RadioShack.com> writes:

> Thanks for your response.
>
> I changed pg_hba.conf to include the server ip address as shown below:
> ---
> Local        all        trust
> Host        all        123.456.789.10        255.255.255.0
> password
> ---
>
> But still have the same result (users can login with any password if local
> is set to trust). The web server is on the same machine as the database, no
> java used.
>
> Did I misunderstand your comment regarding telling the webserver to connect
> using an IP address?

Yes.

You need to set the webapp's database config to make it connect to
an IP address instead of using the Unix socket (which it does by
default for same-machine connections).  I can't tell you how to do
this because you haven't said what language/app server you're using
for the website.

-Doug

В списке pgsql-general по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: contrib/lo and restoring databases
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: The folding of unquoted names to lower case in PostgreSQL