Skip to main content

Backing up and Recovering PostgreSQL on CentOS

Hands-On Lab


Photo of

Training Architect





PostgreSQL is the world's most advanced open source database. Its stability, functionality, and extensibility make it a primary choice for an RDBMS solution.

In this hands-on lab scenario you are the DBA for Awesome Company. You have built a PostgreSQL database backend to facilitate the development of a new web application. To make sure development and testing accurately reflect real life, you need to restore production data to a test environment.

Performing the tasks of this lab will help you become familiar with backup and recovery for PostgreSQL databases. This includes performing backups, restoring backups, and scheduling backup jobs.

What are Hands-On Labs?

Hands-On Labs are scenario-based learning environments where learners can practice without consequences. Don't compromise a system or waste money on expensive downloads. Practice real-world skills without the real-world risk, no assembly required.