PostgreSQL
TMA-POSTGRES-7.3
Ensure base backups are configured and functional
中级别 1人工审核postgres
说明
A 'base backup' is a copy of the PRIMARY host's data cluster ($PGDATA) and is used to create STANDBY hosts and for Point In Time Recovery (PITR) mechanisms. Base backups should be copied across networks in a secure manner using an encrypted transport mechanism.
检查方式
审计方法: 人工审核
此项建议无法自动检查。当您传入 --include-manual 时,扫描结果会列出该项并附带这些说明。
Confirm that base backups (pg_basebackup, pgBackRest or similar) exist, are taken on a regular schedule, are stored off-host, and that restores are tested.
修复方式
修复方法: 操作指南或基础设施补丁
Schedule regular base backups (e.g. pg_basebackup -D <dir> -Ft -z -P or pgBackRest), store them separately from the database server with restricted access, and test restores.
属性
- 操作系统
- 任意
- 标签
- postgresdatabasebackupmanual
- 参考
- CIS PostgreSQL 18 Benchmark v1.0.0 - 7.3 Ensure base backups are configured and functional