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

From: "John Chase" <jchase(at)mtcsc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: 8.3.5, can't connect to server (server doesn't listen)
Date: 2009-02-09 20:12:38
Message-ID: FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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, and are meant to be delivered solely for the use of the intended recipient(s). If you are not the intended recipient, please do not read, copy, use, forward or disclose the contents of this communication to others. Interception of e-mail is a crime under the Electronic Communications Privacy Act, 18 U.S.C. 2510-2522 and 2701-2709. If you have received this email in error, please immediately notify us by return email or by telephone at [703-221-0200 Ext 51119] and promptly delete this message. Thank You.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jan-Peter Seifert 2009-02-09 20:53:35 Re: 8.3.5, can't connect to server (server doesn't listen)
Previous Message John Lister 2009-02-09 20:09:22 Re: database corruption help