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 0BC47D9A94 for ; Wed, 28 Sep 2005 09:57:40 -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 98361-08 for ; Wed, 28 Sep 2005 12:57:07 +0000 (GMT) Received: from netbox.unitech.com.ar (unknown [200.32.92.34]) by svr1.postgresql.org (Postfix) with ESMTP id BAF8ED9A48 for ; Wed, 28 Sep 2005 09:57:07 -0300 (ADT) Received: from yahoo.com.ar (dariop.unitech.com.ar [192.168.1.237]) by netbox.unitech.com.ar (8.11.6/8.11.6) with ESMTP id j8SE66G28436 for ; Wed, 28 Sep 2005 10:06:11 -0400 Received: from 127.0.0.1 (AVG SMTP 7.0.344 [267.11.8]); Wed, 28 Sep 2005 09:57:27 -0300 From: "Dario" To: Subject: Re: Configure foreign host for PostgreSQL 8.0.3 on WindowsXP Date: Wed, 28 Sep 2005 09:57:27 -0300 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE6C7A0C@algol.sollentuna.se> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.075 required=5 tests=[AWL=0.025, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/302 X-Sequence-Number: 19039 this line host all all 192.168.2.120/24 md5 ---------------- makes no sense to me, and probably neither to postgresql, it should be: 192.168.2.120/32 # if 192.168.2.120 is your client, this should be enough or 192.168.2.0/24 # if you wanted to allow all host in subnet to validate thru md5, use this long life, little spam and prosper. -----Mensaje original----- De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]En nombre de Magnus Hagander Enviado el: miercoles, 28 de septiembre de 2005 5:14 Para: Todd Rockhold; pgsql-admin@postgresql.org Asunto: Re: [ADMIN] Configure foreign host for PostgreSQL 8.0.3 on WindowsXP > 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." Check: 1) the listen_address='*' didn't "take". Make sure you remembered to remove the comment sign (yup, i've seen that mistake manu times). Also, you need to restart the service after you've changed that, perhaps you forgot it? 2) Is there any chance that the postmaster is running on a non-default port? Or that the client is connecting on a non-standard port? 3) Verify that the IP Npgsql connects to is correct. If you're using a DNS name, make sure it resolves right. If all those look right, run a "netstat -na" on the commandline and see if there is a listener to port 5432 and what IP that one is bound to. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend