I Dropped My Database! Now What? - A Dive Into PostgreSQL Backup Using pgBackRest
summary
Demonstrates recovering a dropped table from a PostgreSQL physical base backup plus WAL archives using pgBackRest for automated point-in-time recovery; creates a base backup, accumulates WAL files, restores to a timestamp and successfully returns ~19,000–21,000 rows that were present before the accidental DROP. Shows manual restore steps (stop server, copy data and archive, create recovery.signal with target timestamp) and then how pgBackRest automates restore, edit of postgresql.conf and promotion, reducing human error. Also covers WAL archiving and checkpoint/IO implications.
AI-written summary · about
chapters (12)
- 0:00Start
- 0:43Agenda
- 3:05Types of Backups
- 3:53What Is the Difference from Incremental and Differential
- 6:57High Availability
- 12:07Point in Time Recovery
- 17:04Remote Backup
- 34:14Recover the Database
- 37:29Point-in-Time Recovery
- 43:11Cpu Usage
- 45:16Memory Settings
- 46:44Shared Buffers
related talks
50mPostgreSQL Backup and Recovery Methods
48mCTRL+Z for your Database : Mastering Backup and Recovery in PostgreSQL
41mpgBackRest: Elevating PostgreSQL Backup Game
22mPostgreSQL Disaster Recovery Fundamentals
49mTools for Creating PostgreSQL Backups
49mWhat can't pgBackRest do for you?
56mPostgreSQL Backup Strategies
29mYou Don't Need a Database Backup Policy