Обсуждение: 8.3.5, can't connect to server (server doesn't listen)

Поиск
Список
Период
Сортировка

8.3.5, can't connect to server (server doesn't listen)

От
"John Chase"
Дата:
I have two XP laptops connected to each other via cross-over cable. They
ping each other, they connect to each other's drives, no firewalls or
port filter is installed or enabled.

8.3.5 installed on 192.168.10.10
pgAdmin 1.8.4 installed on 192.168.10.12.

Here are the important bits from postgresql.conf and pg_hba.conf:

-- postgresql.conf -- (remainder of file is default with no changes,
including port set to 5432)

#listen_addresses = '*'            # what IP address(es) to listen
on;

-- pg_hba.conf -- (remainder of file is default with no changes)

host    all         all         127.0.0.1/32          md5
host    all         all         192.168.10.0/24       trust

I have restarted the services after making changes. On client (.12) when
I try to connect to server (.10) via pgAdmin I get "Server doesn't
listen" (and appropriate Guru Hint). On server (.10) Wireshark shows SYN
from 2015 to 5432, then RST, ACK from 5432 to 2015.

I've done a lot of reading in docs and online, including the archives
for this list. I've tried many different options in the two above
mentioned file with no change in results. The settings shown above seem
to be the most viable from all that I've read, but still no dice. I
would appreciate ideas on how to further troubleshot this problem.

Important Notice: This email message and any attachments may contain information and/or trade secrets that are private,
andare meant to be delivered solely for the use of the intended recipient(s). If you are not the intended recipient,
pleasedo not read, copy, use, forward or disclose the contents of this communication to others. Interception of e-mail
isa crime under the Electronic Communications Privacy Act, 18 U.S.C. 2510-2522 and 2701-2709. If you have received this
emailin error, please immediately notify us by return email or by telephone at [703-221-0200 Ext 51119] and promptly
deletethis message. Thank You. 



Re: 8.3.5, can't connect to server (server doesn't listen)

От
Jan-Peter Seifert
Дата:
John Chase wrote:

> #listen_addresses = '*'            # what IP address(es) to listen
> on;

umm. is the '#' still there?
Then the changes have no effect, because the line is commented out ...

Peter

Re: 8.3.5, can't connect to server (server doesn't listen)

От
Ivo Rossacher
Дата:
Did you remove the # sign from the beginning of the line below?
>
> #listen_addresses = '*'            # what IP address(es) to listen
> on;

Are you sure there is no line before the following lines which does match?
The first line matches wins.
>
> -- pg_hba.conf -- (remainder of file is default with no changes)
>
> host    all         all         127.0.0.1/32          md5
> host    all         all         192.168.10.0/24       trust
>

Best regards
Ivo