Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 6F55C2E4282 for ; Sat, 15 Dec 2007 05:12:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 60594-02 for ; Sat, 15 Dec 2007 05:11:59 -0400 (AST) Received: from ctb-mesg4.saix.net (ctb-mesg4.saix.net [196.25.240.74]) by postgresql.org (Postfix) with ESMTP id 0232C2E4285 for ; Sat, 15 Dec 2007 05:12:02 -0400 (AST) Received: from klaydual (dsl-245-187-128.telkomadsl.co.za [41.245.187.128]) by ctb-mesg4.saix.net (Postfix) with ESMTP id 5BB6C25BF for ; Sat, 15 Dec 2007 11:11:57 +0200 (SAST) From: "Klay Martens" To: Subject: pg_hba.conf is driving me nuts Date: Sat, 15 Dec 2007 11:11:53 +0200 Message-ID: <000701c83efa$8c570b40$0100000a@klaydual> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6822 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 Importance: Normal Thread-Index: Acg++ohkzGe2ql7uQtSICIi0yc4E6w== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200712/113 X-Sequence-Number: 27630 Hi all, I was not quite sure if this is the right forum for this question (if it aint.oh well). =20 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.=20 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! =20