pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John Chase <jchase@mtcsc.com>
To: pgsql-admin@postgresql.org
Subject: 8.3.5, can't connect to server (server doesn't listen)
Date: Mon, 9 Feb 2009 15:12:38 -0500
Message-ID: <FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM> (raw)

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.





view thread (3+ messages)  latest in thread

Message-ID: <FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM>
Permalink:  ../FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM/
Also on:    postgresql.org/message-id/FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: jchase@mtcsc.com
  Subject: Re: 8.3.5, can't connect to server (server doesn't listen)
  In-Reply-To: <FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM>
  References: <FB8E264F6469914FA02A3B847B448D2C02375A86@MAIL.ITSFAC.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox