This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 10-17-201808:58 AM - edited on 02-27-202001:28 PM by KylieF
Welcome to part 4 of the Supporting Promote series. In this series, we will tackle some common issues and questions, and provide best practices for troubleshooting. This article will demonstrate backing up and restoring your Promote PostgreSQL database.
It seems our PostgreSQL database is corrupted. How can we restore the database?
Start by reviewing the backup databases that are available.
In order to verify the available bundles, run:
sudo yum install tree
When prompted (y/n) to install, enter y
Next, run the command below on the original Master node. It should produce a tree of sub-directories:
Now that we can see all of the db-backups that are available. In this case, we will restore the database based on the ".tar.gz" file that is available.
In the unlikely event that the promote_db-data volume gets corrupted, you can restore your database using the following commands:
First, SSH into the master node:
Copy the DB password:
Run pg_restore on the promote database and use your restoration file: