X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8B2F79FA5DC for ; Wed, 9 Aug 2006 10:35:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85390-04 for ; Wed, 9 Aug 2006 10:35:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 737D79FA385 for ; Wed, 9 Aug 2006 10:35:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from serendipity-interactive.com (unknown [62.254.183.162]) by svr4.postgresql.org (Postfix) with ESMTP id 1B4555AFB1F for ; Wed, 9 Aug 2006 13:35:15 +0000 (GMT) Received: from /spool/local by serendipity-interactive.com with XMAIL for from ; Wed, 9 Aug 2006 14:35:01 +0100 Received: from mysi.co.uk [[10.1.0.45]] by serendipity-interactive.com with XMAIL; Wed, 9 Aug 2006 14:34:59 +0100 Subject: Re: pg_hba.conf includes MIME-Version: 1.0 Date: Wed, 9 Aug 2006 14:32:36 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] pg_hba.conf includes thread-index: Aca6KVSM+PaIfNL2Q+SYiUVW/yQmRABb/k5w From: "Adam Fernie" To: x-cbid: 02BE16E3-A5A9-6147-A1E4-286FCA2C7945 x-cbparentid: 5DAEB8DB-8DD2-2A40-A6E8-6B00E1B8619B Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Message-Id: <20060809133515.1B4555AFB1F@svr4.postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200608/115 X-Sequence-Number: 22658 Hi, I understand how the subnetting works. What I had problems with was putting more than one IP address / hostname into the include file. If my include file looks like so... 1.2.3.4 Then it works fine If the include file looks like this... 1.2.3.4 1.2.3.5 Then it doesn't work (for either address) and I get an error like... psql: FATAL: missing or erroneous pg_hba.conf file Hope someone can help here... Adam -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Richard Broersma Jr Sent: 07 August 2006 14:58 To: Adam Fernie; pgsql-admin@postgresql.org Subject: Re: [ADMIN] pg_hba.conf includes > host dbname all @myhosts 255.255.255.255 md5 > > If I put a single ip or hostname in the file it works a treat but I > don't know how to include more than 1 host or IP address is the file. > Should it be comma seperated, newline for each file or something > different? You can add additional lines for each IP. Or if all of your clients are on the same sub-network, then you can alter your net mask in the above line to allow them. i.e. <255.255.255.0> So for example if your client is 191.168.1.100 and your next mask is 255.255.255.0, then all ip like 192.168.1.* will be allowed to connect. Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Scanned by Serendipity Interactive - MYmailSAFE Scanned by Serendipity Interactive - MYmailSAFE