Presented by:

Rilwan Musa
My name is Rilwan Musa, a data aficionado with over 15+ years of experience in data architecture and a deep dive into machine learning (ML) and artificial intelligence (AI); I have honed my expertise in creating innovative data solutions. Recently, I have been consulting in the financial sector, optimizing data strategies, and implementing AI-driven decision-making tools. As a startup entrepreneur, I drive technological innovation and create impactful solutions. Additionally, I am passionate about helping people transition into the IT field, providing training, guidance, and support to those seeking to build successful careers in technology.
No video of the event yet, sorry!
Disasters happen, whether hacking, human mistakes, or technology failure. Maintaining business continuity as database administrators depends critically on how fast and effectively your PostgreSQL setup can recover. We'll cover the key disaster recovery techniques that every PostgreSQL professional should be aware of in this brief 20-minute talk.
Key topics include:
- Understanding PostgreSQL Backup Types: A quick comparison of logical and physical backups and when to use each.
- Configuring Reliable Backups: Step-by-step guidance on using pg_basebackup, WAL archiving, and tools like pgBackRest for automated, consistent backups.
- Point-in-Time Recovery (PITR): How to set up and execute PITR to restore data to a specific moment, minimizing data loss.
- High Availability and Failover: Introduction to replication and failover strategies using streaming replication and tools like Patroni for seamless recovery.
- Testing Your Recovery Plan: Best practices for validating backups and simulating disaster scenarios to ensure readiness.
The purpose of this session is to offer practical examples and actionable insights to assist you in the development and maintenance of a robust disaster recovery plan for your PostgreSQL database. This presentation is designed to provide you with the knowledge and confidence necessary to protect your PostgreSQL environment from unforeseen disruptions, regardless of whether you are a novice or seasoned DBA.
- Date:
- 2025 March 21 14:30 EDT
- Duration:
- 20 min
- Room:
- Space Coast 3
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Ops
- Difficulty:
- Easy