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。