Horton

Re: vacuumdb: permission denied for schema "pg_temp_7"

vaibhave postgres <postgresvaibhave@gmail.com>

View thread
From: vaibhave postgres <postgresvaibhave@gmail.com>
To: Christophe Pettus <xof@thebuild.com>
Cc: Nathan Bossart <nathandbossart@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
Date: 2024-09-24T01:35:41Z
Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. vacuumdb: Schema-qualify operator in catalog query's WHERE clause.

  2. reindexdb: Skip reindexing temporary tables and indexes.

  3. vacuumdb: Skip temporary tables in query to build list of relations

  4. Use catalog query to discover tables to process in vacuumdb

Looks like Michael has already sent the updated patch from the discussions
in this thread so far. Let me know if anything else needs to be done.

Thanks.

On Tue, Sep 24, 2024 at 6:43 AM Christophe Pettus <xof@thebuild.com> wrote:

>
>
> > On Sep 23, 2024, at 18:09, vaibhave postgres <postgresvaibhave@gmail.com>
> wrote:
> > Yes I plan on continuing with working this.
>
> Great!
>
> One related but not identical thing that has come up with vacuumdb is that
> it terminates if it's not able to connect to any database that it finds in
> the initial query.  This can happen if pg_hba.conf denies the user that is
> running vacuumdb access to a database that comes up during --all.  Some
> hosting providers (in particular, Google) create restricted databases in
> the cluster that a customer role can't get access to.  This pretty much
> defeats --analyze-in-stages.  My suggested fix was to terminate with an
> error if the initial connection fails, but continue with a warning if
> further connections fail.
>
> If it seems reasonable, I'm happy to do it in a separate patch.