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 in the postgres database of the pg_default tablespace to persist WDR snapshot data. By default, the initial user or users with the MONADMIN permission can access and operate objects in 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.

• Original Information of WDR Snapshots
  
• WDR Snapshot Data Table