Re: Problem to connect to the Windows Port - Mailing list pgsql-general

From Anony Mous
Subject Re: Problem to connect to the Windows Port
Date
Msg-id 00bf01c48b63$880af860$6902a8c0@PETER
Whole thread Raw
In response to Re: Problem to connect to the Windows Port  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
I've been watching this thread because I am experience exactly the same
thing.  I can also repeat all the diagnostic results of Conni.  Postmaster
resides on a Win 2K box.  I can telnet to the server no problem.  My pg_hba
file line entries will allow access from all hosts, all users, all databases
on ip 192.168.0.0 with a mask of 0.0.0.0 method=trust.

Connection to the postmaster on the local machine works just fine, but I
just cannot get it to connect remotely.


-----Original Message-----
From: Jan Wieck [mailto:JanWieck@Yahoo.com]
Sent: August 25, 2004 8:27 PM
To: Cornelia Boenigk
Cc: pgsql-general
Subject: Re: Problem to connect to the Windows Port

On 8/25/2004 3:11 PM, Cornelia Boenigk wrote:
> Hi all
>
>> "Connection refused" suggests that you've got a firewall-type
> problem,

Hi Conni,

Gruß aus Philadelphia

connection refused means at least that the machine responded to the
connection attempt, but that (it pretended?) nobody is listening on the
port.

The firewall I would set up would not respond at all, but simply drop
the packet. So I doubt you're facing a firewall problem here. Are you
sure that you are trying to contact the right host?


Jan

>
> The port 5432 is open in bith directions.
> I can connect to remote databases from all machines and all OS without
> any problem. Inside the local network I can access the databases in a
> Cygwin-installation on another machine from the Windows Port but not
> vice versa.
>
>> netstat -an and look for the row that say LISTENING on port 5432 ?
>
> On both machines there is the line
> TCP    0.0.0.0:5432           0.0.0.0:0              LISTENING
>
> Regards
> Conni
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: "Robert Deme"
Date:
Subject: unsubscribe
Next
From: Christopher Browne
Date:
Subject: Re: stone-age maintenance procedures ;-)