Configure foreign host for PostgreSQL 8.0.3 on WindowsXP - Mailing list pgsql-admin

From Todd Rockhold
Subject Configure foreign host for PostgreSQL 8.0.3 on WindowsXP
Date
Msg-id 1e3c2a3a050928003337b50f19@mail.gmail.com
Whole thread Raw
List pgsql-admin
Installed PostgreSQL 8.0.3 on WindowsXP.  Have not been able to configure so that a client program running on a different WindowsXP box can connect to the PostgreSQL database.

As I understand the documentation, at least one of the following configurations should work, but none do.  What have I done wrong and how can I configure so that a connection can be successfully made?


1) The postgresql.conf file has (with everything else being the installation default values):

listen_addresses = '*'

2) None of the following configurations of the pg_hba.conf file worked (the program runs on 192.168.2.120):

# IPv4 local connections:
#host    all         all         127.0.0.1/32          md5
host    all         all            192.168.2.120/24       md5

# IPv4 local connections:
#host    all         all         127.0.0.1/32          md5
host    all         all            192.168.2.120 255.255.255.255       md5

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all         192.168.2.120/24       md5

# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
host    all         all            192.168.2.120 255.255.255.255       md5

I have a Symantec personal firewall installed which I turned off during testing.

The program runs fine on localhost.

Am using the Npgsql .NET library.  The Npgsql.Npgsql.Open() call throws an exception, the error text of which is "System.Net.Sockets.SocketException: NO connection could be made because the target machine actively refused it."

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Preventing database access (including valid users in
Next
From: "Magnus Hagander"
Date:
Subject: Re: Configure foreign host for PostgreSQL 8.0.3 on WindowsXP