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.