Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DB0912E018C for ; Sat, 15 Dec 2007 07:40:07 -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 67683-03 for ; Sat, 15 Dec 2007 07:39:49 -0400 (AST) Received: from ctb-mesg-1-3.saix.net (ctb-mesg-1-3.saix.net [196.25.240.81]) by postgresql.org (Postfix) with ESMTP id 263F92E0183 for ; Sat, 15 Dec 2007 07:40:04 -0400 (AST) Received: from klaydual (dsl-245-187-128.telkomadsl.co.za [41.245.187.128]) by ctb-mesg-1-3.saix.net (Postfix) with ESMTP id E4759A87D for ; Sat, 15 Dec 2007 13:39:44 +0200 (SAST) From: "Klay Martens" To: Subject: Re: pg_hba.conf is driving me nuts Date: Sat, 15 Dec 2007 13:39:44 +0200 Message-ID: <000001c83f0f$37df75b0$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 Importance: Normal Thread-Index: Acg/Dy/5BcSB8G9eSIqsoNutHHc3OQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/116 X-Sequence-Number: 27633 Hi..yes, I have set the "listen_addresses" to "*"...rather an obvious = first stop...As I said - I have no problems connecting locally, or on a LAN - = no sweat at all. Simply cannot get the connection to work from another = network over a WAN. I believe the problem stems from my not setting pg_hba.conf correctly, but I would love to test this! This is my pg_hba.conf file from my developement box: # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all 10.0.0.0/24 md5 host all all 0.0.0.0 0.0.0.0 md5 At one stage, I even looked up the source ip address reported by aports = when I was logged onto the machine remotely..even that address did not work. = So I figure there is a problem with the subnet mask (don't realy understand = the address masks all that well - I am a programmer, not a network tekkie, = so it is kind of new territory for me). What I was wondering is if there was = some way to allow any host to connect, regardless of ip and subnet which was = the behaviour I expected from the 0.0.0.0 0.0.0.0 setting - of course it did absolutely nothing.