pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed8.3.5, can't connect to server (server doesn't listen)
3+ messages / 3 participants
[nested] [flat]
* 8.3.5, can't connect to server (server doesn't listen)
@ 2009-02-09 20:12 John Chase <jchase@mtcsc.com>
0 siblings, 2 replies; 3+ messages in thread
From: John Chase @ 2009-02-09 20:12 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 8.3.5, can't connect to server (server doesn't listen)
@ 2009-02-09 20:53 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
parent: John Chase <jchase@mtcsc.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jan-Peter Seifert @ 2009-02-09 20:53 UTC (permalink / raw)
To: John Chase <jchase@mtcsc.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: 8.3.5, can't connect to server (server doesn't listen)
@ 2009-02-09 23:15 Ivo Rossacher <rossacher@bluewin.ch>
parent: John Chase <jchase@mtcsc.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ivo Rossacher @ 2009-02-09 23:15 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2009-02-09 23:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-02-09 20:12 8.3.5, can't connect to server (server doesn't listen) John Chase <jchase@mtcsc.com>
2009-02-09 20:53 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
2009-02-09 23:15 ` Ivo Rossacher <rossacher@bluewin.ch>
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