Pg 14, if it matters.
When doing maintenance (including a giant pg_restore), sometime one wants to run with different configuration values (like archivemode=off, wal_level=minimal, autovacuum=off, etc).
I could edit postgresql.conf -- or have two of them: one normal, and one for doing maintenance -- but if I'm going to restart anyway, why not just pass those parameters directly to the postmaster?
Alas, those config values are remembered in postmaster.opts. But I don't want that.
Thus: is there a way to tell pg to
not put those options in postmaster.opts?
Or is this my only option before restarting for production:
which postgres > $PGDATA/postmaster.opts
--
Born in Arizona, moved to Babylonia.