Received: from localhost (pluto.hub.org [200.46.204.4]) by postgresql.org (Postfix) with ESMTP id 6F4999F9F08 for ; Fri, 17 Nov 2006 18:43:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.4]) (amavisd-new, port 10024) with ESMTP id 21000-04 for ; Fri, 17 Nov 2006 18:43:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 224E49FA08A for ; Fri, 17 Nov 2006 18:43:20 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kAHMhBjl021706; Fri, 17 Nov 2006 17:43:11 -0500 (EST) To: Paul Forgey cc: pgsql-admin@postgresql.org Subject: Re: remote connections to Windows based server In-reply-to: References: Comments: In-reply-to Paul Forgey message dated "Fri, 17 Nov 2006 13:39:53 -0800" Date: Fri, 17 Nov 2006 17:43:11 -0500 Message-ID: <21704.1163803391@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/174 X-Sequence-Number: 23701 Paul Forgey writes: > I am running the pre-built Windows version of postgresql 8.1. I have > a local LAN with a 10.6/16 network. Apparently there's something more > than what's in the FAQ or my interpretation of the manual to get > remote connections working. > pg_hba.conf: > host all all 10.6/16 md5 > host all all 127.0.0.1/32 md5 > postgresql.conf: > listen_address = '*' > C:] psql -U postgres -d postgres -h swift > psql: FATAL: no pg_hba.conf entry for host "10.6.1.226", user > "postgres", database "postgres", SSL off Hm, that sure looks like it should work, or at least not fail in that particular way. Are you sure you restarted or SIGHUP'd the postmaster after setting up the pg_hba.conf file? regards, tom lane