Warda Bibi sets up a backup management system:
Recently, we worked with a client who was manually backing up their 800GB PostgreSQL database using pg_dump, which was growing rapidly and had backups stored on the same server as the database itself. This setup had several critical issues:
- Single point of failure: If the server failed, both the database and its backups would be lost.
- No point-in-time recovery: Accidental data deletion couldn’t be undone.
- Performance bottlenecks: Backups consumed local storage, impacting database performance.
Read on to see how pgbackrest can address each of these concerns.