From: Todd Rockhold <toduro@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Configure foreign host for PostgreSQL 8.0.3 on WindowsXP
Date: Wed, 28 Sep 2005 00:33:14 -0700
Message-ID: <1e3c2a3a050928003337b50f19@mail.gmail.com> (raw)
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 <http://192.168.2.120;):
# IPv4 local connections:
#host all all 127.0.0.1/32 <http://127.0.0.1/32; md5
host all all 192.168.2.120/24 <http://192.168.2.120/24; md5
# IPv4 local connections:
#host all all 127.0.0.1/32 <http://127.0.0.1/32; md5
host all all 192.168.2.120 <http://192.168.2.120;
255.255.255.255<http://255.255.255.255>md5
# IPv4 local connections:
host all all 127.0.0.1/32 <http://127.0.0.1/32; md5
host all all 192.168.2.120/24 <http://192.168.2.120/24; md5
# IPv4 local connections:
host all all 127.0.0.1/32 <http://127.0.0.1/32; md5
host all all 192.168.2.120 <http://192.168.2.120;
255.255.255.255<http://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."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: toduro@gmail.com
Subject: Re: Configure foreign host for PostgreSQL 8.0.3 on WindowsXP
In-Reply-To: <1e3c2a3a050928003337b50f19@mail.gmail.com>
References: <1e3c2a3a050928003337b50f19@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox