Horton

Re: add missing PQfinish() calls to vacuumdb

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2025-02-05T00:36:00Z
Lists: pgsql-hackers 
On Tue, Feb 04, 2025 at 10:30:58AM -0600, Nathan Bossart wrote:
> I noticed that vacuum_one_database() doesn't call PQfinish() before
> pg_fatal() in a few of the server version checks.  I seem to have
> unintentionally established this precedent in commit 00d1e88.  Michael
> claimed to have fixed it before committing [0], but that seems to have been
> missed, too.  I don't think this is a huge problem, but it does seem nicer
> to properly close the connection before exiting.  If there are no
> objections, I plan to commit and back-patch the attached patch shortly.
> 
> [0] https://postgr.es/m/20190108020300.GH22498%40paquier.xyz

Indeed.  It looks like my fingers have slipped during a rebase for
this one, or something like that.  The incorrect pattern has spread
later in ae78cae3be62, not 4211fbd8413b.

Thanks for the fix, Nathan.
--
Michael

Commits

  1. vacuumdb: Add missing PQfinish() calls to vacuum_one_database().

  2. Add --min-xid-age and --min-mxid-age options to vacuumdb