Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 4FD8F9F9B3F for ; Fri, 17 Nov 2006 18:11:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 98816-01 for ; Fri, 17 Nov 2006 18:11:14 -0400 (AST) X-Greylist: delayed 00:30:53.923004 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 6F6859FA0E9 for ; Fri, 17 Nov 2006 18:11:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from tiddles.aphrodite.com (tiddles.aphrodite.com [216.231.47.120]) by svr4.postgresql.org (Postfix) with ESMTP id 32D665AF02A for ; Fri, 17 Nov 2006 21:40:18 +0000 (GMT) Received: from [10.6.1.234] (spot.aphrodite.trillium [10.6.1.234]) (authenticated bits=0) by tiddles.aphrodite.com (8.13.7/8.13.6) with ESMTP id kAHLdssP019429 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO) for ; Fri, 17 Nov 2006 13:39:54 -0800 Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: pgsql-admin@postgresql.org From: Paul Forgey Subject: remote connections to Windows based server Date: Fri, 17 Nov 2006 13:39:53 -0800 X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/172 X-Sequence-Number: 23699 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 C:] psql -U postgres -d postgres Password for user postgres: If I remove the 127.0.0.1 line from pg_hba.conf, I cannot connect at all. What more do I need to do?