X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4504E9FB265 for ; Mon, 7 Aug 2006 10:58:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 68392-06 for ; Mon, 7 Aug 2006 13:57:59 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31810.mail.mud.yahoo.com (web31810.mail.mud.yahoo.com [68.142.207.73]) by postgresql.org (Postfix) with SMTP id 6B0969FB25B for ; Mon, 7 Aug 2006 10:57:57 -0300 (ADT) Received: (qmail 59982 invoked by uid 60001); 7 Aug 2006 13:57:56 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=d/zgWHwOgK3PP/+TTM+uOvLLdGWHiGIOrf22MlHTp4Svcft1FGFAxtV289zTuouty2riu95c9mdCbqXs7oqLZsJ3YXYP9GuJtyccep5KEr7g64oZSXLQgnW86wqxhets98x4JN2MQSoSvmvfzJyrQGrE8IAl4QljuDDqGL9VGfg= ; Message-ID: <20060807135756.59980.qmail@web31810.mail.mud.yahoo.com> Received: from [63.203.180.122] by web31810.mail.mud.yahoo.com via HTTP; Mon, 07 Aug 2006 06:57:56 PDT Date: Mon, 7 Aug 2006 06:57:56 -0700 (PDT) From: Richard Broersma Jr Subject: Re: pg_hba.conf includes To: Adam Fernie , pgsql-admin@postgresql.org In-Reply-To: <20060807132355.41D625AF032@svr4.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200608/72 X-Sequence-Number: 22616 > 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.