Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZYZ5-00591I-M3 for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Feb 2024 15:49:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rZYZ2-00AjT5-J5 for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Feb 2024 15:49:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZYZ2-00AjSx-9W for pgsql-hackers@lists.postgresql.org; Mon, 12 Feb 2024 15:49:48 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rZYYz-006pVO-NF for pgsql-hackers@postgresql.org; Mon, 12 Feb 2024 15:49:47 +0000 Received: by mail-io1-xd35.google.com with SMTP id ca18e2360f4ac-7bf2c826a5aso167975039f.0 for ; Mon, 12 Feb 2024 07:49:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1707752983; x=1708357783; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=qf46RHl0rOGZHLe6b6Jge+eJjz2JXkclWdB7fRwRHU0=; b=BNIK/jKuNYWLbiikUv/yh/b7SoWzDLivPtDYSelhliGow3yp3A1svNX03yBKdLzsEF 5iGLysw4QvdBquqHydBR/Rt1jJCsLlXpPy3erI7cPaUqXEN9JXuROcMiX7Wnot9DGYBB xYacvx6MOYRCAnbPsRx4U75DUpjABA2Q+8aJ6dn08CVflJb1BmV4FV0NAKH1y0jqQ53B xhkdJBl9ngiv+DS+/C5uNa91HQxfdYT0wqShhb3RIIEXWCRF7v5zKi5Fp5T/AJkYHtMM 3k9d5gSLgJZK/POfjkcLXleYuiRSDMfPHTyMH2JY4BomJ/seF5QEIYHo8udndOpcYPKn CWHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1707752983; x=1708357783; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=qf46RHl0rOGZHLe6b6Jge+eJjz2JXkclWdB7fRwRHU0=; b=SsaM+yYfLTOw+CKWH41eIdLXJLVBDP2AqBGBr38kwyhTi+LCv4pnPjhdhAN7DlQH9j 3ZYSfs41RgZZvjY2qaW1+WhsZeSeJM/ZCPP22Ex2We1Zt8dEMrFf9lEdo479NfNLPRQa Nk4L3BJH40PlEbd4w/+zMoBYyJyFaKWTUUbypWD7re0LWtYgOIfY3qwHEjOtGEoHW02S D35rt9VUVh496GXmuV/7lOnn9V5/KUnMqS75i3gLfnwwKkXdhQcM2Odr9SZ9EJlnFSIS KjxXKKl5V2v2jlsZBCfnolm29ToNOXW5LovqzBYiuOvgqorLvXyWxiRrt4L+m6z4p8Vk gnww== X-Gm-Message-State: AOJu0YzsSL4GQHx/5ND7nIRY/iUKGPTQyAiIfijsQ8mVtKKEmu33aBa9 Bf/Q/4lFyCCLShL4ANay0gj4sl8vNjpIZJrI9p5LwhNPEVbW65xgDfW9gApN X-Google-Smtp-Source: AGHT+IFd8QspcqoHhIk3MfXCNCBzbsWOIIfAvSQLSvC3RxqQ9AYIFgKRhysdVAm99/1yt49hb9PUOw== X-Received: by 2002:a05:6e02:eeb:b0:363:bcae:f77f with SMTP id j11-20020a056e020eeb00b00363bcaef77fmr8036195ilk.0.1707752983583; Mon, 12 Feb 2024 07:49:43 -0800 (PST) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id cr1-20020a056e023a8100b00361a166564csm1951705ilb.4.2024.02.12.07.49.43 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 12 Feb 2024 07:49:43 -0800 (PST) Date: Mon, 12 Feb 2024 09:49:45 -0600 From: Nathan Bossart To: Pavlo Golub Cc: pgsql-hackers Subject: Re: [PATCH] allow pg_current_logfile() execution under pg_monitor role Message-ID: <20240212154945.GA1645880@nathanxps13> References: <20240209163657.GC663211@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Feb 12, 2024 at 12:27:54PM +0000, Pavlo Golub wrote: >> Are there any other >> functions that pg_monitor ought to have privileges for? >> > Not that I'm aware of at the moment. This one was found by chance. Okay. I'll plan on committing this in the next few days. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com