Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1poOeN-0003WB-KX for pgsql-general@arkaria.postgresql.org; Mon, 17 Apr 2023 13:12:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1poOeM-0003ab-5M for pgsql-general@arkaria.postgresql.org; Mon, 17 Apr 2023 13:12:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1poOeL-0003aP-O5 for pgsql-general@lists.postgresql.org; Mon, 17 Apr 2023 13:12:05 +0000 Received: from mail-yb1-xb32.google.com ([2607:f8b0:4864:20::b32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1poOeF-003QwB-8O for pgsql-general@lists.postgresql.org; Mon, 17 Apr 2023 13:12:05 +0000 Received: by mail-yb1-xb32.google.com with SMTP id o11so6745308ybk.11 for ; Mon, 17 Apr 2023 06:11:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1681737117; x=1684329117; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=tBeZ8ywp2pbrEac1Q/KDiNI7aEIlKLPzeyTxQxGMd40=; b=MzE4+DCPp6m0Mtj6aK2Z9BDilMuhqb5xIwIxFA0UN1a/yf30F3XTetwMbHYBPUUcvO W3fl8IEefCCtNN1sl7JBX8Bd8EdRKf8Gy76IckH+tYTcVr81E/m6/QUSbieA+6VOTcjU VMTXhCGJgCBzrx2cO5yClekYNBDNzPQCi69UOwiRuYPrmDQZ0KqrocZSSfjqWhYiM7V/ /6eX+un6m8YHtO8vdevEcrnqqqKjCYCpDeStMcI1ofQhb8hz6xk/NtorJMHz5f3H4FdM RW3z/pE3Fxu0MHWjvF9YPt2GqAhtsve3mTUsakLyiqGT1rBWdNUwga0GS32NhDmxzdM6 XvFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681737117; x=1684329117; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=tBeZ8ywp2pbrEac1Q/KDiNI7aEIlKLPzeyTxQxGMd40=; b=Tnxvc8/83e5j8Dgew892TjMnPBEEQl7My5oiaQ1j++q+GgPz5qeRZhlE3Rkyq9lUQB i3pnNPW0M3r7cKBw7zC76/G+EwsjiXreSvqVXAqPaK/BfKbgrGlg+z9RxguCu6BAHIrs kHW1V8k37YecKOi14EAU+h4hDkB5PmmwW1xAtz0KTdqUqFIqDBEy6IVPJODZgwtVsKvu krqxM9uLyMF8FIkadxVp8hNPu32vVWq4yL5V651Ww8wXEQ+2VZcDDtSuWUBeh9ThxvFb u6RiO/VC9/Dz8bAdqbBfYN+qQcIV+EQPqytG6wY6UqLuZ53IOmBIPt3UG/EnBInFjcCE RvFA== X-Gm-Message-State: AAQBX9cHZ1SI7efbi3UEyiqw0+Bhi9r2wV5Z+09W/Fwmbk0p89eNi63z 09O0MHXvYC7IFX4bNftI+9nMicf/ItA= X-Google-Smtp-Source: AKy350Y9ax5clmKcpY86K0qYtUMcGyM+4Blcm2MKdgnkrtNBnpYKvRaw0/HnWCb55RmFlXTfMw+Kgg== X-Received: by 2002:a05:6902:1882:b0:b92:3edc:d4fe with SMTP id cj2-20020a056902188200b00b923edcd4femr5472796ybb.10.1681737116605; Mon, 17 Apr 2023 06:11:56 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:cd5e:8860:7bc9:6e9e? ([2600:1700:bd2c:b810:cd5e:8860:7bc9:6e9e]) by smtp.googlemail.com with ESMTPSA id m2-20020a258002000000b00b7767ca7485sm2948606ybk.34.2023.04.17.06.11.56 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 17 Apr 2023 06:11:56 -0700 (PDT) Message-ID: <4dcbad87-4727-9649-9d1d-f5c1aa768b83@gmail.com> Date: Mon, 17 Apr 2023 08:11:54 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: Suppress logging of "pg_hba.conf rejects connection for host" Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <009701d97074$75f02550$61d06ff0$@1nar.com.tr> From: Ron In-Reply-To: <009701d97074$75f02550$61d06ff0$@1nar.com.tr> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/16/23 10:02, ertan.kucukoglu@1nar.com.tr wrote: > Hello, > > One of the systems running PostgreSQL 14.7 receive a lot of lines like in > the subject. I have below pg_hba.conf line and that line causes these to be > logged. > > host all all 0.0.0.0/0 reject > > If possible, I do not want to see these lines in my logs. But, I failed to > find a parameter for it. > > Is it possible to turn this specific message logging off? 1. Why do you need that line, instead of just allowing in the addresses you want? 2. Why are you getting so many "illegal" connection attempts? 3. Auditors like to see that you're rejecting "illegal" connection attempts. -- Born in Arizona, moved to Babylonia.