- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Core Tech
PostgreSQL Disaster Recovery & Failover
Master PostgreSQL disaster recovery and high availability techniques through hands-on practice. You'll implement comprehensive backup strategies, configure point-in-time recovery, and set up streaming replication with failover capabilities. Working with CarvedRock's critical database infrastructure, you'll ensure business continuity through proven disaster recovery procedures. After completing this lab, you will be able to: - Execute logical and physical PostgreSQL backups. - Restore databases from backup files. - Configure and perform point-in-time recovery (PITR). - Set up streaming replication between servers. - Execute manual failover procedures. - Troubleshoot common recovery scenarios.
Lab Info
Table of Contents
-
Challenge
The Last Objective
Welcome to the final objective! This is your last chance to experiment in the environment.
-
Challenge
Implement Backup Strategies and PITR
To start, you'll establish a robust backup foundation for CarvedRock's PostgreSQL database. You'll execute logical backups for specific databases using pg_dump, perform full physical backups with pg_basebackup, and configure continuous archiving for point-in-time recovery (PITR). After simulating a data loss incident, you'll restore the database to a specific timestamp, demonstrating your ability to recover from both planned maintenance and unexpected disasters.
-
Challenge
Configure Replication and Perform Failover
In this objective, you'll establish high availability using PostgreSQL streaming replication. You'll configure a standby server that continuously receives updates from the primary, monitor replication status to ensure data consistency, simulate a primary server failure scenario, and promote the standby to become the new primary server. This setup provides CarvedRock with the ability to maintain database operations even during unexpected outages.
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.