Cancelling "vacuum full" in single user mode?

From: "Colin 't Hart" <colinthart(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cancelling "vacuum full" in single user mode?
Date: 2023-10-02 12:39:59
Message-ID: CAMon-aT_uh7ZFsQwHFbMmL+iYMeBbJaprxKVWWcHs9MT-PXBJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a customer approaching transaction wraparound, about 3million
transaction IDs away at the moment.
Postgres 9.5 (yes, I know...)

Somewhat mislead by the message to vacuum the database in single user
mode, they are now in single user mode and are running "vacuum full"
on the "worst" database, which has 18.5 million tables, and is about
350GB on disk.

Now we want to cancel the "vacuum full" and run a "vacuum freeze"
instead... or preferably, start back up in multiuser mode and run
vacuum there, but that was running very slowly while autovacuum was
trying to run (so we would need to disable that too, for now).

So,

1. Can we cancel safely?
2. Any other suggestions? Upgrade to a newer version right now?

/Colin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wim Bertels 2023-10-02 12:48:27 specifying multiple options in URI psql behaviour?
Previous Message Colin 't Hart 2023-10-02 12:38:32 Cancelling "vacuum full" in single user mode?