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 1qoTFs-001NoH-EK for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Oct 2023 18:39:24 +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 1qoTFq-00GdXm-C1 for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Oct 2023 18:39:23 +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 1qoTFq-00GdXe-0M for pgsql-hackers@lists.postgresql.org; Thu, 05 Oct 2023 18:39:22 +0000 Received: from mail-vk1-xa2f.google.com ([2607:f8b0:4864:20::a2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qoTFn-000DQS-M4 for pgsql-hackers@lists.postgresql.org; Thu, 05 Oct 2023 18:39:22 +0000 Received: by mail-vk1-xa2f.google.com with SMTP id 71dfb90a1353d-49dc95be894so495145e0c.2 for ; Thu, 05 Oct 2023 11:39:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1696531158; x=1697135958; darn=lists.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=lMqA3pa9wxuxkfynlmdna3LR7OfudLLdJYKZj//xVYo=; b=TMzYEG+50Sn6kFWt/FWJ3dQkQK5u5XwSEuCT3QWvy58B2mMFCCarAjqCxQxCckZnda S8W3z01aKYKYM9Hh1445YMDSCy1k14KFMEUji8POFiMaHk3gw12dIu0FcL2x1Hk6Hv6R 5XXPNaQSVIszjBEWLlBS4b+QaXHyKwrfTYW+cPU8f0FePL8IAE2UElEO9IDSuJlScgHf 7EZGS98dSuP36ZSL4DfUpgeR2/UJFBGlZ9iY4OZvam+Y1lDtlevDe9XvASlsPVldWm1X VOH1zNKvWPx+tZepodmtLSXovuOuaXlAp+TJKcNK9hqbu9AAIDeqetJo+tbI02KHlo8t InHQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1696531158; x=1697135958; 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=lMqA3pa9wxuxkfynlmdna3LR7OfudLLdJYKZj//xVYo=; b=ANE/iLnYdAwwQjn14gmFNltYckWC9AdmDNefNzXySmjJ2bmk/iF/xMg58jVOCIpFkP WVSF792iFAUCW1dlxq7grr8Z6gG/GPaIkj1YkCki3ZmhbkoxCtHKdXr6N/DDdFqVXTtQ VBiWYYw2zVvefIuYgd+xDbDQewHj9UT5TPbLjs5GfHZU5u1uJVBkh2tWNjd4WxbhoQ+K +h1nmK4GMq1KdxTHLEjFhwudZqyH8/Mj0Q5LFImpg9Fk6fGG7P/Zc546DdjmwJk5EQDe uDmIuiGOfyWox7B40pirWeu5qOzEhs1WywKOZEOJHwrNTpUlgLh4Wni5T7dx1db1DLn6 bC5Q== X-Gm-Message-State: AOJu0YyvWnT+/Mf88LYp/HciHKJIXsA073HAZJ0ADy7xjV8myvG7LyZh dvtP3hIfu++tr9r6MZSixxA= X-Google-Smtp-Source: AGHT+IEptQWpumTastodqvZ7b1AoE3B9rX2XTwnBZFpQq5H1+d++AKQs7SdWXJTQNkqhmvVPapTYxg== X-Received: by 2002:a1f:c305:0:b0:49a:b737:4df7 with SMTP id t5-20020a1fc305000000b0049ab7374df7mr5250991vkf.5.1696531157806; Thu, 05 Oct 2023 11:39:17 -0700 (PDT) Received: from nathanxps13 (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id b14-20020ac844ce000000b0041a1323352asm465050qto.67.2023.10.05.11.39.16 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 05 Oct 2023 11:39:17 -0700 (PDT) Date: Thu, 5 Oct 2023 13:39:15 -0500 From: Nathan Bossart To: Bharath Rupireddy Cc: "Drouvot, Bertrand" , Michael Paquier , PostgreSQL Hackers Subject: Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag Message-ID: <20231005183915.GA151257@nathanxps13> References: <566c1686-c80b-4d4a-b496-b00ac428a095@gmail.com> <83f72bb9-f3cf-4344-8d4d-45e128813d58@gmail.com> <26e7cd6a-6dd1-4b08-975b-62603eeb6f3f@gmail.com> 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 Thu, Oct 05, 2023 at 05:51:31PM +0530, Bharath Rupireddy wrote: > I think changing BGWORKER_BYPASS_ALLOWCONN to 0x0001 and having bits32 > for InitPostgres inputs load_session_libraries and > override_allow_connections can be 0001 in this patch series so that it > can go first, no? This avoids the new code being in the old format and > changing things right after it commits. +1 -- Nathan Bossart Amazon Web Services: https://aws.amazon.com