Re: problem connecting from another host

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problem connecting from another host
Дата
Msg-id 15329.992478948@sss.pgh.pa.us
обсуждение исходный текст
Ответ на problem connecting from another host  (Frank Miles <fpm@u.washington.edu>)
Ответы Re: problem connecting from another host  (Frank Miles <fpm@u.washington.edu>)
Список pgsql-general
Frank Miles <fpm@u.washington.edu> writes:
> The error log shows:

>     No pg_hba.conf entry for host abc.de.fg.hij, user fpm, database fpm

> while in the pg_hba.conf I have an entry:

>     host    fpm     abc.de.fg.hij           255.255.255.255         trust

> (Initially it wasn't "trust", but first I want to get *some* connection).

That looks fine to me, assuming that "abc.de.fg.hij" actually stands for
the numeric IP (*not* DNS name) of the client machine.

Sometimes people are confused about what IP address they're really
connecting from, if they are running any sort of virtual IP or
multi-interface setup.  Might wanna double check it.  However, the
error message should show the source IP, so you probably would have
noticed already if that were it.

If you are looking only at the error message returned to the client, try
looking in the postmaster log as well.  Sometimes there's extra info
written to the log.

            regards, tom lane

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

Предыдущее
От: "Rob Arnold"
Дата:
Сообщение: Re: abs() does not exists..
Следующее
От: Ian Lance Taylor
Дата:
Сообщение: Re: Log files, how to rotate properly