Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h81J1-0007DM-Mv for pgsql-admin@arkaria.postgresql.org; Sun, 24 Mar 2019 11:28:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h81J0-0008NR-9c for pgsql-admin@arkaria.postgresql.org; Sun, 24 Mar 2019 11:28:46 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1h81Iz-0008NK-Up for pgsql-admin@lists.postgresql.org; Sun, 24 Mar 2019 11:28:46 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h81It-00044k-2J for pgsql-admin@postgresql.org; Sun, 24 Mar 2019 11:28:45 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1553426915; bh=lWvZyfOO9UbuZY/PH10WC5y0S6zM/5Raipq5XEalEvQ=; h=X-UI-Sender-Class:Date:From:To:Cc:Subject:References:In-Reply-To; b=iooxhk4HEfrF9Axkpwn1iPDHo6lhyuLv0aeFDaR3ljlBMhF34/q006GXU29lQ0MAo to7hDeG3KoCLn0mAmOJGmqhwEKMT7Q0cq+oP67A7vrBZ6m6Olspre1Tdr/1pa9/DeK Lwd8XzmwiIuOsHiymPd6TqKvAH7/j0mWo2ZRXNNk= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from nighthawk.caipicrew.dd-dns.de ([188.174.61.168]) by mail.gmx.com (mrgmx001 [212.227.17.190]) with ESMTPSA (Nemesis) id 0MV6EP-1hUkgQ2laP-00YV1J; Sun, 24 Mar 2019 12:28:35 +0100 Received: from mbanck by nighthawk.caipicrew.dd-dns.de with local (Exim 4.84_2) (envelope-from ) id 1h81HC-0000wC-0Z; Sun, 24 Mar 2019 12:26:54 +0100 Date: Sun, 24 Mar 2019 12:26:53 +0100 From: Michael Banck To: Shreeyansh Dba Cc: pavan95 , pgsql-admin Subject: Re: Is there a way to log only a particular user connection attempts in Postgres? Message-ID: <20190324112653.GA27613@nighthawk.caipicrew.dd-dns.de> References: <1553228652335-0.post@n3.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) X-Provags-ID: V03:K1:xiel7tJdIqWoAVP3Aq7RTXPmh2jCK1ZYDnt5wSn9bmUAyMPQ84D XHvAEU2z3TXTsIpfKZ1rUSTI7qImJf/N+s42pRVoHxYbucXy1Z9ElvK4ZthyC5LQIUmvEXU 6TyCVWb11j7/0UsDS+x2E3ODB+HBzkOYobNMQe0xjd23G1QCtIZ0L93eN6sn1Mm93StH79x aK3U9gPUkHIT1TCxosS6w== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:Hm47EqgCaBc=:yFaazNkjfTisNeDowl/4Cs gxd7hTBPmWuH7NNyOWYorSNfnyLR4Q24jBk4y7+L/Mj9PvhUjC6MbDM+FR/FYC3Snq5iuCgyw pgYzDL+DYoX+uJBrrqJFpmsyceREDDS+boVDnpCNggDn9sqNaWjJwloGqsSyUIbGoNJxGC+Qq nnUIbQRbvkIKO0g1w+AakDRZ0Aftj44PQZ88UE52jGIwFKZY7/vlJBm5lOLNPNusxKLTYaM5A TMNthynoW0EClUGk4L4B8tP9lb2oGvsfO/Y/r2EzA9QgxVW3Pgvbhyr4amp5rq3kDYUIXpvRw 2AwzcT1s4vPF7DiO04dp805d+ziqUEJpvofMdmAvFgp/f2Iu8G+xFujnfGuYQ481dF7jhZIgm kVROiemdLnzajzHX8OWlfBGfFv8T38fLrBZAprnj5/f0Mlp05C98Y8VHc7qhNXWngC48w4j9d fMgDySuZS8MMZHa9laSktJBJR2SMEeA1NkwyBCtIeEXVTCUBAY43wORxFoNjcsc4437EXRMPQ VSlBe5EMkd+xc1lzXWc+G9fnBfcFpkhKrlq8CxWrX8/o8QdukDm9dkS1wAsi2g3jmWsShaL3B rVCVTr3HptZTSEv//hX6iVDTneoITUR3BgUT+MWKJqi3OubqUFKQoY9yUetOJ1R7e5a+4svBV cHaldYvdeUDqI378ic9xVmszMIUg/ckrJsY4Nly2o/g9Vw7YrYmCl6yHziB/iWqxmmU0rqnQa iB2h46oo893lmHyvjd5IP0MXRMyWfgJklOpCJNamLi+R/9/m880tXXvs3tUA6g19jFyuBT/up PH37kN8xDuhMvXx6/pKBXshGVezlxBEwbOgncGcneKQ10EZ0F/RVZnstUrRpVQNpWPXYaRbcw c0cXLeDEy8jyEnAOCT0DF3KDTMcsYt5dqDx+GSci0yEyXMJwB9f5l7oumrPaVV List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On Fri, Mar 22, 2019 at 02:21:33PM +0530, Shreeyansh Dba wrote: > Go through the below link hope this will help you. > https://dba.stackexchange.com/questions/118018/is-it-possible-to-exclude-specific-users-in-log-activity-of-postgresql That qustion/answer is about exluding general log messages for some user, not excluding connection (attempts)/disconnections for some user. Michael