Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 880582E4282 for ; Sat, 15 Dec 2007 05:24:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85214-05-2 for ; Sat, 15 Dec 2007 05:24:39 -0400 (AST) Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id 129402E41B7 for ; Sat, 15 Dec 2007 05:24:52 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 2260CB2545 for ; Sat, 15 Dec 2007 10:24:51 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id XTQGbh6N+hJn for ; Sat, 15 Dec 2007 10:24:51 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 0EDC7B24ED; Sat, 15 Dec 2007 10:24:51 +0100 (CET) Date: Sat, 15 Dec 2007 10:24:51 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: pg_hba.conf is driving me nuts Message-ID: <20071215092451.GB5005@easy2.in-chemnitz.de> References: <000701c83efa$8c570b40$0100000a@klaydual> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <000701c83efa$8c570b40$0100000a@klaydual> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/114 X-Sequence-Number: 27631 Hi Klay, On Sat, Dec 15, 2007 at 11:11:53AM +0200, Klay Martens wrote: > I was not quite sure if this is the right forum for this question (if it > aint.oh well). > > I have had a postgresql server up and running smoothly for 1.5 years now - > no problems at all..but: > I now need to be able to administer the server remotely, as well as allow > remote logins from a WAN. > Now, I have set up all the appropriate port forwarding, made sure that there > are no problems with firewalls on the server.but the dratted thing will not > allow any connections from a remote pgAdmin. > I am fairly sure this is a result of a problem with pf_hba.conf.Can anyone > advise how to configure pg_hba.conf to permit connections from any subnet > and ip? I know this is not really a good idea, but if the connection works, > at least then I know where the problem is! As it is, I cannot be sure > exactly where the connection failure is. Very annoying! What is the exact error message when you try to connect? As stated on top of pg_hba.conf, you may permit whole subnets access like this: host all all 192.168.xxx.0/24 trust Note: This is dangerous, replace "trust" by a method of your choice! But it's good for testing. Bye, Tino. -- www.craniosacralzentrum.de www.lebensraum11.de www.spiritualdesign-chemnitz.de Tino Schwarze * Parkstraße 17h * 09120 Chemnitz