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 1mbRGD-00064Y-9C for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Oct 2021 17:44:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mbRGB-0005jI-8U for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Oct 2021 17:44:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mbRGA-0005j9-V0 for pgsql-bugs@lists.postgresql.org; Fri, 15 Oct 2021 17:44:47 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mbRG8-0008OC-DN for pgsql-bugs@lists.postgresql.org; Fri, 15 Oct 2021 17:44:46 +0000 Received: from [192.168.28.53] (cyclops.postgrespro.ru [93.174.131.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 9FBCF21C1D41; Fri, 15 Oct 2021 20:44:41 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1634319881; bh=dqjqkodTRegXU6GwjMAA/Sxrfr7lNG4JbcOZ6iI7hEQ=; h=Date:Subject:To:Cc:References:From:In-Reply-To; b=CPRRj+vL1dptyLBZaXwkLB+VWZFG/SqXkmttrAXeol+5v38nUvW31iFkLPTPdZeNG JM95jJEPRcdalz/GFIDks5m2tzXoJjRHDn5kdhl/yp2uLNoJj3hoSDRP2b/6t/y9Kp SeQ0XZ2RTkmjif6+gSayw7JGqL87iPaOBbna5SB4= Message-ID: <9ed84986-76dd-774c-14b5-3e41e79d376f@postgrespro.ru> Date: Fri, 15 Oct 2021 22:44:41 +0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.2.0 Subject: Re: SET SESSION AUTHORIZATION command doesn't update status of backend Content-Language: en-US To: Tom Lane Cc: PostgreSQL mailing lists References: <76ae5aaf-1843-4d84-0430-f35da7f786b9@postgrespro.ru> <952987.1634305805@sss.pgh.pa.us> From: Andrey Lepikhov Organization: Postgres Professional In-Reply-To: <952987.1634305805@sss.pgh.pa.us> 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 15/10/21 18:50, Tom Lane wrote: > I don't think this is a bug. pg_stat_activity is reporting the session's > login identity, and that seems fine, though maybe the documentation about > it needs to be clarified. Thank you. Documentation is quite correct. I should be more attentive. -- regards, Andrey Lepikhov Postgres Professional