功能模块WDR:
操作步骤及问题现象:
1、gs_guc reload -N all -I all -c "enable_wdr_snapshot=on"
2、select create_wdr_snapshot();
3、select * from snapshot.snapshot; There was no result, nor after the restart.截图信息:
openGauss=# select name,setting from pg_settings where name like '%wdr%'; name | setting -----------------------------+--------- enable_wdr_snapshot | on wdr_snapshot_interval | 60 wdr_snapshot_query_timeout | 100 wdr_snapshot_retention_days | 8 (4 rows)
openGauss=# select create_wdr_snapshot(); create_wdr_snapshot ----------------------------------------- WDR snapshot request has been submitted (1 row)
openGauss=# select * from snapshot.snapshot; snapshot_id | start_ts | end_ts -------------+----------+-------- (0 rows)发布于 2022-08-24 02:00:21
如果没有快照,请查看pg_log……中的日志
https://stackoverflow.com/questions/73340851
复制相似问题