Pausing and resuming

Pause an auto_mv during a maintenance window:

SELECT pgauto_mv.update_mv(
    p_mv_schema => 'reporting',
    p_mv_name   => 'daily_revenue',
    p_is_active => false
);

While paused: - Watch-table events are still recorded in the event log. - No refresh runs. If a scheduled slot fires, it is recorded as skip_reason = 'inactive' and the next slot is queued. - The schedule configuration is preserved.

Resume:

SELECT pgauto_mv.update_mv(
    p_mv_schema => 'reporting',
    p_mv_name   => 'daily_revenue',
    p_is_active => true
);

After resuming, the schedule restarts from the existing definition — no need to re-supply schedule parameters.

---