Updated on 2024-06-03 GMT+08:00

WDR Snapshot Schema

After the WDR snapshot function is enabled (the GUC parameter enable_wdr_snapshot is set to on), objects are created in the snapshot schema of user tablespace pg_default and database postgres to flush WDR snapshot data. By default, the initial user or the monadmin user can access and operate the object of the snapshot schema.

You can set the GUC parameter wdr_snapshot_retention_days to automatically manage the snapshot lifecycle.

Do not add, delete, or modify tables in the snapshot schema. Manual modification or damage to these tables may cause WDR exceptions or even WDR unavailability.