On Tue, 2019-10-29 at 21:17 -0700, Irene Yeh wrote:
> Here are some issues we're having right now
> 1. The DB started autovacuum after we created a unique index. It's been running
> for a really really long time and it won't let us alter the table to add null constraint.
> I tried to cancel the autovacuum job but it just starts backup.
If it blocks ALTER TABLE, it must be an anti-wraparound autovacuum.
Let it finish before you continue. Once this necessary maintenance job
is done, you will be able to proceed.
Yours,
Laurenz Albe
--
+43-670-6056265
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com