Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cC7tz-0007hX-N6 for pgsql-admin@arkaria.postgresql.org; Wed, 30 Nov 2016 16:38:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cC7tz-0004Ik-59 for pgsql-admin@arkaria.postgresql.org; Wed, 30 Nov 2016 16:38:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cC7sH-0002Oc-88 for pgsql-admin@postgresql.org; Wed, 30 Nov 2016 16:36:49 +0000 Received: from col004-omc3s8.hotmail.com ([65.55.34.146]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cC7sD-0008JV-MH for pgsql-admin@postgresql.org; Wed, 30 Nov 2016 16:36:48 +0000 Received: from EUR01-VE1-obe.outbound.protection.outlook.com ([65.55.34.136]) by COL004-OMC3S8.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008); Wed, 30 Nov 2016 08:36:43 -0800 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=axDpF8gueHvKzuAW6Ej7viB6LDutcSeqPbATF8/QTE4=; b=dBBxUjHLGp5kB+5cuX46EHU2Rk2QS34QePQzhjjvDOA9zO06Nfg/vbRbUKRRAD8Z3PbFKpgI/eNlLpTp2kivKFU0A1/cMjkQC1D5FHt+rVM63eYIlbhn1S2gCNWWOQJxmrf0pUQijkfEaiCoHW7P8uPUxLVeWUzZlHMoHt6EaxuFXmX1igHCwrPWosAjwZh9BG0W9o0N73TsXo0xG/sX2iss2bd2C8fhx11qJh1j3ZUxCuhQFN1DtKOzn1b2tGNZYPBjspna7iZPEj5lMchIY2YgI5yM1gojLgSn8gx3OOf63NtE2a8VrdEKQtYVP1H92whoRJsMCGNyaisoPurTLA== Received: from HE1EUR01FT006.eop-EUR01.prod.protection.outlook.com (10.152.0.60) by HE1EUR01HT089.eop-EUR01.prod.protection.outlook.com (10.152.1.47) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.734.4; Wed, 30 Nov 2016 16:36:40 +0000 Received: from AM5PR10MB0689.EURPRD10.PROD.OUTLOOK.COM (10.152.0.53) by HE1EUR01FT006.mail.protection.outlook.com (10.152.1.228) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.734.4 via Frontend Transport; Wed, 30 Nov 2016 16:36:40 +0000 Received: from AM5PR10MB0689.EURPRD10.PROD.OUTLOOK.COM ([10.167.221.145]) by AM5PR10MB0689.EURPRD10.PROD.OUTLOOK.COM ([10.167.221.145]) with mapi id 15.01.0747.015; Wed, 30 Nov 2016 16:36:40 +0000 From: Sathesh S To: "pgsql-admin@postgresql.org" Subject: Basic question on 'reject' auth-method in pg_hba.conf Thread-Topic: Basic question on 'reject' auth-method in pg_hba.conf Thread-Index: AQHSSx8fUFC0VtTFfkuqMH4pDm/Dhw== Date: Wed, 30 Nov 2016 16:36:40 +0000 Message-ID: Accept-Language: en-GB, en-US Content-Language: en-GB X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=hotmail.com; x-incomingtopheadermarker: OriginalChecksum:;UpperCasedChecksum:;SizeAsReceived:7275;Count:36 x-tmn: [yY9kOa84k3wC063WN8BKihPKCSVU4jgQ] x-incomingheadercount: 36 x-eopattributedmessage: 0 x-microsoft-exchange-diagnostics: 1;HE1EUR01HT089;7:aP0O1KfVHvSKIttsoZFM3/G4EUniPYYChlIpkc0/2oM7o46J0MGRDYRHUPw5Aj1NhJG1gsfhcGFJpMJryZdy97zcDVP+IyfMBZitOKtDX6Oesoo3O3Qy14TIXZeYM3gvf2NSv3/PsWJsZKWvWCMiPKrtRevpUZh4KXLEvF1e0leQkGhp4FmQVaFcBST4aQoRfImDs8XiweJ6lZCMxLSGHqPO/3hL6k5q4BnXJKebDLi212xLbazNRdve+g+lmVHfAQSkaXj1vx3qZ8JrvkuZHQ+do5AJBwY8nISr2mz7tvRthnQ9/3dQQMT0xOmd7RdfMO3AznYVgBCUlmsBpBMbL4lbYVUPd+qOQhNVWH7Sfjg= x-forefront-antispam-report: EFV:NLI;SFV:NSPM;SFS:(10019020)(98900003);DIR:OUT;SFP:1102;SCL:1;SRVR:HE1EUR01HT089;H:AM5PR10MB0689.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;LANG:en; x-ms-office365-filtering-correlation-id: 19cf07d8-a62d-4842-d813-08d4193f0fe4 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(1601124038)(1603103113)(1601125047);SRVR:HE1EUR01HT089; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(432015012)(82015046);SRVR:HE1EUR01HT089;BCL:0;PCL:0;RULEID:;SRVR:HE1EUR01HT089; x-forefront-prvs: 0142F22657 spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_AM5PR10MB068902CBAA704A68CEA2FB79828C0AM5PR10MB0689EURP_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Nov 2016 16:36:40.5351 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1EUR01HT089 X-OriginalArrivalTime: 30 Nov 2016 16:36:43.0419 (UTC) FILETIME=[EF164EB0:01D24B27] X-Pg-Spam-Score: -4.9 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_000_AM5PR10MB068902CBAA704A68CEA2FB79828C0AM5PR10MB0689EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello All, I'm new to postgresql, I have a basic question in using the 'reject' auth-m= ethod in pg_hba.conf. I would like to reject a particular login from multiple range of IP address= es. For example: I want to reject login "test" from multiple IP ranges "100.101.13.0" & "200= .101.13.0" My questions: 1. Do I need to make separate entires like below ones or can I separate th= e IP address range using comma? "host all test 100.101.13.0 reject" "host all test 200.101.13.0 reject" 2. If I make multiple entries to reject as above, how will it be treated, w= ill the system read all the entries for the "test" login or will it stop af= ter it finds the 1st entry for "test" login? Can you please help with above questions. Thanks, Sathesh --_000_AM5PR10MB068902CBAA704A68CEA2FB79828C0AM5PR10MB0689EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello All,


I'm new to postgresql, I have a basic q= uestion in using the 'reject' auth-m= ethod in pg_hba.conf.

I would like to reject a particular log= in from multiple range of IP addresses.


For example:


I want to reject login "test"= from multiple IP ranges "100.101.13.0" & "200.101.13.0&= quot;


My questions:


1.  Do I need to make separate ent= ires like below ones or can I separate the IP address range using comma?


"host   all  test  = 100.101.13.0  reject"

"host   all  test = ; 200.101.13.0  reject"

2. If I make multiple entries to reject as= above, how will it be treated, will the system read all the entries for th= e "test" login or will it stop after it finds the 1st entry for &= quot;test" login?

Can you please help with above questions.


Thanks,

Sathesh

--_000_AM5PR10MB068902CBAA704A68CEA2FB79828C0AM5PR10MB0689EURP_--