Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3A0DEB5FDE3 for ; Mon, 6 Jun 2011 13:32:03 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 25998-04 for ; Mon, 6 Jun 2011 16:31:55 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 9E243B5FE63 for ; Mon, 6 Jun 2011 13:31:55 -0300 (ADT) Received: by wya21 with SMTP id 21so2924787wya.19 for ; Mon, 06 Jun 2011 09:31:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=8Qh29e4tFhLvPs1Jh0RMOJHW0Spn/dBzz6CDOzseGcE=; b=h2nYdfTpb9vYih8tc7kLA8B0JpRIXP3rbiXcNPOJo1OE5xTd4gBiA1RQtL2M1M6IMa kwF6nPD++X/qUdb701XlufgNemlzE+b71nM1C5ZWs4V6TISxvCrML+tZABUgr5xXEZij byq07TnQll3RZg0vFJMRcVJ0L2hLFnhucvpb0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=mmh/WdyOorD2Jc9+nDtTv2IVem4UWpqBGte15uaGXRVDD3r3nz6JDKHnLn5YwNudCw hjo3pBwHEAUt1MeVQ5D5FVHAbiJRPqDkuLUjCF/bKjXNlMKkHkndMTCm5LHaH0fdVLQA 1E/JlViUpJ+Yq+yPzklMQeqGWZfYnnAzzkw+U= MIME-Version: 1.0 Received: by 10.216.68.9 with SMTP id k9mr2613941wed.65.1307377914757; Mon, 06 Jun 2011 09:31:54 -0700 (PDT) Received: by 10.217.1.198 with HTTP; Mon, 6 Jun 2011 09:31:54 -0700 (PDT) Date: Tue, 7 Jun 2011 01:31:54 +0900 Message-ID: Subject: CIDR address in pg_hba.conf From: Fujii Masao To: pgsql-docs Content-Type: multipart/mixed; boundary=000e0ce0cf383241b904a50da42b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201106/20 X-Sequence-Number: 6794 --000e0ce0cf383241b904a50da42b Content-Type: text/plain; charset=ISO-8859-1 Hi, http://developer.postgresql.org/pgdocs/postgres/auth-pg-hba-conf.html > An IP address is specified in standard dotted decimal notation with > a CIDR mask length. The mask length indicates the number of > high-order bits of the client IP address that must match. Bits to the > right of this must be zero in the given IP address. Is the last statement correct? When I specified the following setting in pg_hba.conf, I could not find any problem in PostgreSQL. host all all 192.168.1.99/24 trust As far as I read the code, those bits seem not to need to be zero. Attached patch just removes that statement. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center --000e0ce0cf383241b904a50da42b Content-Type: text/x-diff; charset=US-ASCII; name="hba_v1.patch" Content-Disposition: attachment; filename="hba_v1.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_goln1afk0 KioqIGEvZG9jL3NyYy9zZ21sL2NsaWVudC1hdXRoLnNnbWwKLS0tIGIvZG9jL3NyYy9zZ21sL2Ns aWVudC1hdXRoLnNnbWwKKioqKioqKioqKioqKioqCioqKiAyMzEsMjM4ICoqKiogaG9zdG5vc3Ns ICA8cmVwbGFjZWFibGU+ZGF0YWJhc2U8L3JlcGxhY2VhYmxlPiAgPHJlcGxhY2VhYmxlPnVzZXI8 L3JlcGxhY2VhYmxlPgogICAgICAgICBBbiBJUCBhZGRyZXNzIGlzIHNwZWNpZmllZCBpbiBzdGFu ZGFyZCBkb3R0ZWQgZGVjaW1hbAogICAgICAgICBub3RhdGlvbiB3aXRoIGEgPGFjcm9ueW0+Q0lE UjwvPiBtYXNrIGxlbmd0aC4gIFRoZSBtYXNrCiAgICAgICAgIGxlbmd0aCBpbmRpY2F0ZXMgdGhl IG51bWJlciBvZiBoaWdoLW9yZGVyIGJpdHMgb2YgdGhlIGNsaWVudAohICAgICAgICBJUCBhZGRy ZXNzIHRoYXQgbXVzdCBtYXRjaC4gIEJpdHMgdG8gdGhlIHJpZ2h0IG9mIHRoaXMgbXVzdAohICAg ICAgICBiZSB6ZXJvIGluIHRoZSBnaXZlbiBJUCBhZGRyZXNzLgogICAgICAgICBUaGVyZSBtdXN0 IG5vdCBiZSBhbnkgd2hpdGUgc3BhY2UgYmV0d2VlbiB0aGUgSVAgYWRkcmVzcywgdGhlCiAgICAg ICAgIDxsaXRlcmFsPi88L2xpdGVyYWw+LCBhbmQgdGhlIENJRFIgbWFzayBsZW5ndGguCiAgICAg ICAgPC9wYXJhPgotLS0gMjMxLDIzNyAtLS0tCiAgICAgICAgIEFuIElQIGFkZHJlc3MgaXMgc3Bl Y2lmaWVkIGluIHN0YW5kYXJkIGRvdHRlZCBkZWNpbWFsCiAgICAgICAgIG5vdGF0aW9uIHdpdGgg YSA8YWNyb255bT5DSURSPC8+IG1hc2sgbGVuZ3RoLiAgVGhlIG1hc2sKICAgICAgICAgbGVuZ3Ro IGluZGljYXRlcyB0aGUgbnVtYmVyIG9mIGhpZ2gtb3JkZXIgYml0cyBvZiB0aGUgY2xpZW50CiEg ICAgICAgIElQIGFkZHJlc3MgdGhhdCBtdXN0IG1hdGNoLgogICAgICAgICBUaGVyZSBtdXN0IG5v dCBiZSBhbnkgd2hpdGUgc3BhY2UgYmV0d2VlbiB0aGUgSVAgYWRkcmVzcywgdGhlCiAgICAgICAg IDxsaXRlcmFsPi88L2xpdGVyYWw+LCBhbmQgdGhlIENJRFIgbWFzayBsZW5ndGguCiAgICAgICAg PC9wYXJhPgo= --000e0ce0cf383241b904a50da42b--