Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: vacuumdb: permission denied for schema "pg_temp_7"
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <ZvLM_Rqel-t_58IQ@nathan>
Date: Tue, 24 Sep 2024 08:22:32 -0700
Cc: vaibhave postgres <postgresvaibhave@gmail.com>,
 Tom Lane <tgl@sss.pgh.pa.us>,
 Fujii Masao <masao.fujii@oss.nttdata.com>,
 Noah Misch <noah@leadboat.com>,
 PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>,
 vsekar@microsoft.com
Content-Transfer-Encoding: quoted-printable
Message-Id: <8F7C7040-1163-440E-9182-53AF34C606D4@thebuild.com>
References: <Zu3iMzfiGBTbg3iy@nathan> <20240920215030.8d.nmisch@google.com>
 <2603142.1726873660@sss.pgh.pa.us>
 <5f37ee56-14fb-44fe-9150-9eb97e10538b@oss.nttdata.com>
 <2649165.1726898595@sss.pgh.pa.us>
 <CAM_eQjyWnu_LUt6JWjh3boNFHAT9DBrcbamhG3Xy39Q4Ph=2rg@mail.gmail.com>
 <ZvGye19tHrhLCpFl@nathan> <E9660D68-5B26-488E-9AB2-2CA1E8EDDDA1@thebuild.com>
 <CAM_eQjxZC2RNTGZ0NZLtkZ5DVn1=L6GBrUWzt-MkU4X4k5h60g@mail.gmail.com>
 <FA25664E-EDD5-42BE-AA25-1321E0A0C8BC@thebuild.com> <ZvLM_Rqel-t_58IQ@nathan>
To: Nathan Bossart <nathandbossart@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/8F7C7040-1163-440E-9182-53AF34C606D4%40thebuild.com>
Precedence: bulk


> On Sep 24, 2024, at 07:30, Nathan Bossart <nathandbossart@gmail.com> =
wrote:
> I think it'd be fine to continue with a warning when --all is used, =
but if
> you specify a --dbname that you cannot connect to, then I think it =
should
> fail.

Yes, that's essentially my proposal.  If --all is not specified, or if =
it cannot make the initial connection to determine which databases are =
in the instance, it stops with a fatal error just as it does now.=