Re: pgsql continuing network issues

On Friday 31 March 2006 02: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.
>
> 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.
>
> 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.
>
> Thank you,
>
> David
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

Would it be possible to post the contents of your postgresql.conf and
pg_hba.conf files?

--
Adrian Klaver
aklaver(at)comcast(dot)net