Re: vacuumdb: add --dry-run

Chao Li <li.evan.chao@gmail.com>

From: Chao Li <li.evan.chao@gmail.com>

To: Nathan Bossart <nathandbossart@gmail.com>

Cc: Álvaro Herrera <alvherre@kurilemu.de>, Corey Huinker <corey.huinker@gmail.com>, pgsql-hackers@postgresql.org

Date: 2025-12-08T23:04:24Z

Lists: pgsql-hackers

Commits

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

Add ParallelSlotSetIdle().
- 750816971b35 19 (unreleased) landed
vacuumdb: Add --dry-run.
- d107176d27c7 19 (unreleased) landed
vacuumdb: Move some variables to the vacuumingOptions struct.
- cf1450e57799 19 (unreleased) landed
Log a note at program start when running in dry-run mode
- c05dee191125 19 (unreleased) cited

> On Dec 9, 2025, at 03:24, Nathan Bossart <nathandbossart@gmail.com> wrote:
> 
> On Mon, Dec 08, 2025 at 12:27:26PM -0600, Nathan Bossart wrote:
>> On Mon, Dec 08, 2025 at 07:23:16PM +0100, Álvaro Herrera wrote:
>>> I haven't read this thread, but chanced to come across this and wanted
>>> to note recent commit c05dee191125.  I'm not opposed to changing what
>>> went in there, but let's make them all the same.
>> 
>> Ah, that must've been where I stole from originally.  Will switch it back.
> 
> As promised...
> 
> -- 
> nathan
> <v7-0001-vacuumdb-Move-some-options-to-vacuumingOptions-st.patch><v7-0002-Add-ParallelSlotSetIdle.patch><v7-0003-vacuumdb-Add-dry-run.patch>

I searched over the source tree, and find “Running in xxx mode” in initdb and option.c:

Initdb:
```
printf(_("Running in debug mode.\n"));

printf(_("Running in no-clean mode. Mistakes will not be cleaned up.\n"));```

Options.
```
pg_log(PG_REPORT, "Running in verbose mode”);
```

And “”Executing in dry-run mode” in a few commands: pg_archivecleanup.c, pg_createsubscriber.c, pg_combinebackup.c and pg_rewind.c.

Should we make them all consistent?

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/