pgsql: vacuumdb: Allow specifying objects to process in all databases.

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: vacuumdb: Allow specifying objects to process in all databases.
Date: 2024-03-11 15:34:07
Message-ID: E1rjhfD-003GHn-HD@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

vacuumdb: Allow specifying objects to process in all databases.

Presently, vacuumdb's --table, --schema, and --exclude-schema
options cannot be used together with --all, i.e., you cannot
specify tables or schemas to process in all databases. This commit
removes this unnecessary restriction, thus enabling potentially
useful commands like "vacuumdb --all --schema pg_catalog".

Reviewed-by: Kyotaro Horiguchi, Dean Rasheed
Discussion: https://postgr.es/m/20230628232402.GA1954626%40nathanxps13

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/648928c79bed975a89fa2e4ef8bc0bade8e0e0d8

Modified Files
--------------
doc/src/sgml/ref/vacuumdb.sgml | 60 +++++++++++++++++++++++----------------
src/bin/scripts/t/100_vacuumdb.pl | 24 ++++++++--------
src/bin/scripts/vacuumdb.c | 19 ++++---------
3 files changed, 52 insertions(+), 51 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2024-03-11 16:28:11 pgsql: Add missing connection statuses to docs
Previous Message Heikki Linnakangas 2024-03-11 09:20:47 pgsql: Set all_visible_according_to_vm correctly with DISABLE_PAGE_SKIP