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 1tFQ05-00CtJU-2G for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Nov 2024 03:43:01 +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 1tFQ02-00BeHx-Rq for pgsql-bugs@arkaria.postgresql.org; Mon, 25 Nov 2024 03:42:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFQ02-00BeHQ-3u for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2024 03:42:58 +0000 Received: from mail-pj1-x1032.google.com ([2607:f8b0:4864:20::1032]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tFPzz-003dBa-4Z for pgsql-bugs@lists.postgresql.org; Mon, 25 Nov 2024 03:42:56 +0000 Received: by mail-pj1-x1032.google.com with SMTP id 98e67ed59e1d1-2e56750bb0dso3108446a91.0 for ; Sun, 24 Nov 2024 19:42:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leadboat.com; s=google; t=1732506174; x=1733110974; darn=lists.postgresql.org; h=user-agent: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=Y3wYXmm65V9h0dN/k82whMP4PTwbUsYkgic63qdxhcc=; b=HjOze0P+mDHeMKxL4Z6BTnkblPqM/XjEWuwBXoY9dv4nXkXLHp7w0GILhnOB8f2hFb GzmM8BOusPIKTY0HMjVdiWbr3uFmrKknA60kUHZKOO18nIGW0KRkbnKo9OvzDt7aRD/w BuCKVTsgHriVgu1S0fiBO0NXL9U8oWHDsZgeA= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732506174; x=1733110974; h=user-agent: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=Y3wYXmm65V9h0dN/k82whMP4PTwbUsYkgic63qdxhcc=; b=Nu0vS3qg0ti+0wK4KeLV5ExuWvaZ7DbEkNiJMR4ZCgCsC8Ap1iqQgCAY6CBRiSr3ZL JFzdZvxl65l4yzMnY832WEshc5GUtQRdNhodSiJ5ICf2rzCJ9tm2VEPd/Xn/Ts7kfYfN TZU1PPauSmoEr03ljP7q2C4gt5lZyjMZuw20Ajjm5tZfk/XTNYbWy1a/IFELbCiHZmPW 6zwK9zRUSbffM/d1TXZrUCRbCu/9SrgF3D5L1gK/1Bc6qpYnjEKgr7AkV9JctlUTTX3i 5EugLJCAMbTVKD4RI0JlCQE7qC4tvA/HZgm5lRm1S8dX9sB4SfcblZd9M4qUzLX3EOKH clEA== X-Forwarded-Encrypted: i=1; AJvYcCWLJDoh+XS2OXuacil0hZ4X/dBKe7wM9S3aj4WWHuFBQAOxjLe1tbmbEVakNqlvtEFxzS0b7zsMcy9l@lists.postgresql.org X-Gm-Message-State: AOJu0YztK+6XaZu8bE+00newJzY0tDkv4dMt907AxK+C2JrOut8JpvNU y39Pk7l7hvGeC4BWeHMmWwEMcfRWnZgDgd70G2k5sbe1v9caio5IOK3HQTX/yw== X-Gm-Gg: ASbGncudixsP8NYe+ncgtBe0ORBSkWqQY2STwPXfwRSMnbnFbB6AyxTwBHodQIclVPI X35jfa4ID7RykEr9Y/14rMGjNem9pLvs7reUxLui5Tr5LhVW9VclUT6n5kCDSrK876qod1CuB8Z WMk3/6k1xCoFH/PQ2ykTM1V+W08sElnWeVg+x+tejlLC+f/nLqTQCN7QRhFGBnRNIJmb8xcCSQ6 IQEvt0TLnVuePHYcQ5AGtKyGivfBI8JdcMpp3+bNUqe X-Google-Smtp-Source: AGHT+IFUFmFn5a6X10sN97TRpKBJQk8vYeBVpqui1WQiMY9sk9W5oF0B4G1VA2oYC/D4TYH4ed5jIA== X-Received: by 2002:a17:90b:2f0b:b0:2ea:7cd5:4adf with SMTP id 98e67ed59e1d1-2eb0e890892mr13697749a91.31.1732506173958; Sun, 24 Nov 2024 19:42:53 -0800 (PST) Received: from google.com ([2600:1702:a20:5750::48]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2eb0cfe4b25sm5626275a91.11.2024.11.24.19.42.52 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 24 Nov 2024 19:42:53 -0800 (PST) Date: Sun, 24 Nov 2024 19:42:51 -0800 From: Noah Misch To: Tom Lane Cc: Matthew Woodcraft , pgsql-bugs@lists.postgresql.org, Etienne LAFARGE Subject: Re: Today's Postgres Releases break login roles Message-ID: <20241125034251.28.nmisch@google.com> References: <87iksnsbhx.fsf@golux.woodcraft.me.uk> <2742790.1731771946@sss.pgh.pa.us> <20241116183459.93.nmisch@google.com> <2903185.1731787871@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2903185.1731787871@sss.pgh.pa.us> User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sat, Nov 16, 2024 at 03:11:11PM -0500, Tom Lane wrote: > Noah Misch writes: > > Agreed. I cut some corners by not directly testing that or ALTER DATABASE, so > > here are some more tests. The output is the same on master @ now, on master @ > > 2024-11-10 (before the regression), and on v12. It reproduces the trouble on > > master @ 2024-11-12. That's sufficient confirmation for the moment, so I'll > > hold this until the releases wrap and make it master-only. > > If you only intend to apply it to master, there's no need to wait. True, the delay wasn't obligatory. I pushed it today, for whatever reason.