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:[EMAIL PROTECTED] 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. # #================================================== [EMAIL PROTECTED] # ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
