X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7D8CDD9A41 for ; Wed, 28 Sep 2005 04:33:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 99544-08 for ; Wed, 28 Sep 2005 07:33:13 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.197]) by svr1.postgresql.org (Postfix) with ESMTP id 19D6BD9A3C for ; Wed, 28 Sep 2005 04:33:12 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id x3so546921nze for ; Wed, 28 Sep 2005 00:33:14 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=QlUVrUpzUQZNiG+t/verOGN0Tvua5Yfl0ex5cfNTmqXZQx9/dBg0kopBC1USI3AsEciz9ColtQp0LAyWb/kGG+BMQ4gz/74d2grLqTvRdBPEm96X4eXDWXW5c4Ld3mVrz/crIE+4Fe4iVdLpIPgp/Ldd1xZoGR2EHCoTaVOyEso= Received: by 10.36.247.33 with SMTP id u33mr3758258nzh; Wed, 28 Sep 2005 00:33:14 -0700 (PDT) Received: by 10.36.221.10 with HTTP; Wed, 28 Sep 2005 00:33:14 -0700 (PDT) Message-ID: <1e3c2a3a050928003337b50f19@mail.gmail.com> Date: Wed, 28 Sep 2005 00:33:14 -0700 From: Todd Rockhold Reply-To: Todd Rockhold To: pgsql-admin@postgresql.org Subject: Configure foreign host for PostgreSQL 8.0.3 on WindowsXP MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_862_25805662.1127892794651" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.2 required=5 tests=[HTML_50_60=0.095, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.08, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/298 X-Sequence-Number: 19035 ------=_Part_862_25805662.1127892794651 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 installatio= n default values): listen_addresses =3D '*' 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.255md5 # 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.255md5 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.= " ------=_Part_862_25805662.1127892794651 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 configurat= ions 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 installatio= n default values):

listen_addresses =3D '*'

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    &nb= sp;     md5
host    all         all            192.168.2.120/24   &= nbsp;   md5

# IPv4 local connections:
#host    all         all         127.0.0.1/32    &nb= sp;     md5
host    all         all            192.168.2.120 255.255.255.255       md5

# IPv4 local connections:
host    all         all         127.0.0.1/32    &nb= sp;     md5
host    all         all         192.168.2.120/24   &= nbsp;   md5

# IPv4 local connections:
host    all         all         127.0.0.1/32    &nb= sp;     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 tes= ting.

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."

------=_Part_862_25805662.1127892794651--