That doesn’t have to incur actual downtime if you use pgbouncer in front of Postgres and pause the pool.