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 1mwsP4-0005r6-J6 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Dec 2021 20:58:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mwsP3-00083e-FW for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Dec 2021 20:58:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mwsP2-00083V-SC for pgsql-hackers@lists.postgresql.org; Mon, 13 Dec 2021 20:58:33 +0000 Received: from mail-pg1-x536.google.com ([2607:f8b0:4864:20::536]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mwsOz-0002jF-5O for pgsql-hackers@postgresql.org; Mon, 13 Dec 2021 20:58:32 +0000 Received: by mail-pg1-x536.google.com with SMTP id m15so15584284pgu.11 for ; Mon, 13 Dec 2021 12:58:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=dwPSA5HIxOOQPq5UGxTBOgS3cT3/Zb4bSe28oIVXWs8=; b=TS0Lcj6gcd6GM8cfa/OTERIHZzERBp0SaGGzRr7whuPzh86isRNHPcN2b+89jTdKVO RmpeouZu/IfHlEybu8IJIuKvzn81kqLk1hin2cGSBfQiVHh1S2ZNJ5Kb/TcbKapkzewR ks6r+6fBhMcnP9U+/QDZUvoW9f0UESPReGQ6UgI5ia8IuGKs5RkYeeh/DQKgXXnSCABv 7qqHATy4rK4395hM8NJPEPE29R00VaZC1qq134eRNSTlm76iehh7pP0eRi2t3SwDk+pc v3eA4ACLSJ6p5KCM4fhNB58LBB4E2HRnSyGycq/NaYJ1u/0dOHo1/AZMkOqGgp3HSz57 bKRg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=dwPSA5HIxOOQPq5UGxTBOgS3cT3/Zb4bSe28oIVXWs8=; b=DxW/qj3OZcVj4GBz6Eo0+ypY3XQziVczwyJgEhaim0foWQ01eJzyQCM+1zW3xwFilk 00e86EgQXy42WrEjHk4F0kcHz3bCQ3WhMuSHLbjq+V5dXPkqX+M5aCg5YnZLFZVh4A4M uvIuJ+2HXa5EszLuEPpmolzydKk6lMtSDXNmCLNFISOkw9Ui1ha3HOHTqVSZlUqkkLsS dq920VthuwvuFdKqRpXsUNhrLsfbzU0OnelVI7U06mMeUEKdq/mCFs26ze3eYqku0OWi PvhwAU7lPcarCFKwCfC8SAO1Wz7+bty9ecZ6nH8BkTEPZ+GAkFgHbHmxZbw4ggeTlKfM /fuA== X-Gm-Message-State: AOAM5329tAyutZmiEbOiVH/1nXxH2JjnufHB+QmbZajX4YkXVsMbqYip j7DT33j8Ujsey6iFn7WJaXDkDcBvOWC9r6zFs/R5CkM57+8WJlY5xW7htoc2b9tq09sUVp/PMVq JKqIbH0+ueDh+5Nt34gXdGAVo106IJ1oXis1DG0/p6HwH62rCWFpEcRtuDqx2ShvqGkfzoj+uW1 aO6SQWp1ylDJtE9hX+AWDr8t9RLWlq/WeWbjtY X-Google-Smtp-Source: ABdhPJzGwbxaX0wcr/9DheRFnVmfECKJdmYnIDSMT+epHj7ErlwoRq9wz/BmFgl7OvXdXgF5PYCp1Q== X-Received: by 2002:a05:6a00:124d:b0:4ad:574d:4d2f with SMTP id u13-20020a056a00124d00b004ad574d4d2fmr500925pfi.24.1639429106866; Mon, 13 Dec 2021 12:58:26 -0800 (PST) Received: from laptop280-ma-us.hitronhub.home (24-113-193-150.wavecable.com. [24.113.193.150]) by smtp.gmail.com with ESMTPSA id o15sm11140440pgk.7.2021.12.13.12.58.26 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 13 Dec 2021 12:58:26 -0800 (PST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: Granting SET and ALTER SYSTE privileges for GUCs From: Mark Dilger In-Reply-To: Date: Mon, 13 Dec 2021 12:58:25 -0800 Cc: Robert Haas , Jeff Davis , PostgreSQL-development , Tom Lane Content-Transfer-Encoding: quoted-printable Message-Id: References: <3D691E20-C1D5-4B80-8BA5-6BEB63AF3029@enterprisedb.com> <9DB8DABC-0E1E-4AB0-BB11-9BC48E4C71BE@enterprisedb.com> To: Andrew Dunstan X-Mailer: Apple Mail (2.3608.120.23.2.7) X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Dec 13, 2021, at 12:56 PM, Andrew Dunstan = wrote: >=20 > This patch had bit-rotted slightly, and I was attempting to remedy it. I have that already, and getting ready to post. Give me a few minutes = and I'll repost. > However, I got a failure running the TAP tests because of this change: >=20 >=20 > diff --git a/src/test/modules/test_pg_dump/t/001_base.pl > b/src/test/modules/test_pg_dump/t/001_base.pl > index 16f7610883..7fbf2d871b 100644 > --- a/src/test/modules/test_pg_dump/t/001_base.pl > +++ b/src/test/modules/test_pg_dump/t/001_base.pl > @@ -9,7 +9,12 @@ use PostgreSQL::Test::Cluster; > use PostgreSQL::Test::Utils; > use Test::More; > =20 > -my $tempdir =3D PostgreSQL::Test::Utils::tempdir; > +# my $tempdir =3D PostgreSQL::Test::Utils::tempdir; > +my $tempbase =3D '/tmp/test_pg_dump'; > +my $subdir =3D 0; > +$subdir++ while (-e "$tempbase/$subdir"); > +my $tempdir =3D "$tempbase/$subdir"; > +system("mkdir $tempdir"); > =20 >=20 >=20 > What's going on here? Yeah, I hit that, too. That was an accidentally committed bit of local = testing. Please ignore it for now. =E2=80=94 Mark Dilger EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company