SafeGrd: PostgreSQL backups that are restored and checked on a schedule

SafeGrd is a new backup service for PostgreSQL 13 and later that restores every backup on a schedule and checks the row counts. It takes a backup, restores it later into memory or a throwaway database, and counts what came back, so you find out a backup is broken before you need it. Taking the backup The safegrd daemon runs on a host next to your database and connects as a read-only role. On PostgreSQL 14 and later that role only needs pg_read_all_data . On 13 you grant each schema instead. The schema comes from pg_dump and the rows come over binary COPY , in one transaction. After the first…

在 PostgreSQL News 阅读

2026/10/22 09:00，PostgreSQL News 发布了“SafeGrd: PostgreSQL backups that are restored and checked on a schedule”（类型：版本发布）。相关技术：PostgreSQL。