8.3.5, can't connect to server (server doesn't listen) - Mailing list pgsql-admin

From John Chase
Subject 8.3.5, can't connect to server (server doesn't listen)
Date
Msg-id FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM
Whole thread Raw
Responses Re: 8.3.5, can't connect to server (server doesn't listen)  (Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>)
Re: 8.3.5, can't connect to server (server doesn't listen)  (Ivo Rossacher <rossacher@bluewin.ch>)
List pgsql-admin
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. 



pgsql-admin by date:

Previous
From: John Lister
Date:
Subject: Re: database corruption help
Next
From: Jan-Peter Seifert
Date:
Subject: Re: 8.3.5, can't connect to server (server doesn't listen)