On Mar 31, 2006, at 2:55 AM, David Bernal wrote:
> Hey all,
>
> I wrote a few days ago regarding networking issues I'm having. At this
> point, I'm at my wit's end and am hoping someone can help me.
>
> I am running postgres 8.1.0 on Windows XP w\SP2. I currently have
> PGSQL configured to accept connections from my local IP, 192.168.0.100
> using the listen_addresses directive.
>
> If I try to connect to the database from the same machine using the
> psql program or using NPGSQL (.NET pgsql provider) it simply hangs.
> Nothing happens at all. I don't get errors in my event viewer, nor do
> I get any errors in the textfile log postgresql maintains.
What IP address are you trying to connect to? If you're trying to
connect to 127.0.0.1 and it's listening on 192.168.0.100 then
that won't work.
>
> IF I change the listen_addresses directive to localhost, I can connect
> fine and everything works EXCEPT I get the message "NOTICE: Unknown
> win32 socket error code: 10107" repeatedly anytime I do something.
> This would be acceptable, except that I need to be able to access this
> database at client sites.
10107 is WSASYSCALLFAILURE. A pretty generic message, but I've
seen it when some broken software has inserted itself into the IP
stack.
>
> Can anyone help me or direct me to someone who can? I'm trying to push
> postgres to my clients, because it seems like a great RDBMs, but if I
> can't even get a server to work, I'm going to have to switch to
> something else.
Can you connect to TCP port 5432 using telnet, or somesuch? If
not, are you running any sort of crapware on the windows box that
will break your network stack ("personal firewall" or "antivirus" are
some of the buzzwords there - I'd look at your "personal firewall"
settings first).
Cheers,
Steve