Backing up and Recovering PostgreSQL on CentOS
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.