Re: Postgres does not accept socket connections

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres does not accept socket connections
Дата
Msg-id 3107.1141314551@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres does not accept socket connections  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-general
"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
> am  02.03.2006, um  4:37:02 -0800 mailte kishore.sainath@gmail.com folgendes:
>> psql: could not connect to server: Connection refused
>> Is the server running on host "server-name" and accepting
>> TCP/IP connections on port 5432?

> Check the postgresql.conf for the value "listen_addresses".
> My guess: listen_address is at the moment 'localhost'. Change this to
> the LAN-address or '*'.

If listen_addresses is correct and you still get "Connection refused",
the other thing to look at is the kernel's packet filtering rules
(iptables).  I believe the default configuration on FC4 will reject
external connections to 5432.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Thread scheduling in postgresql 8.1.3 on windows
Следующее
От: Anakreon Mendis
Дата:
Сообщение: Insert fails when it shouldn't