ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Promote Knowledge Base

Definitive answers from Promote experts.

Supporting Promote Series Part 4 - The Promote Database

JohnPo
Alteryx Alumni (Retired)
Created

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:

 

tree /var/promote

 

part 4_1.JPG

 

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.

 

promote-2018.02.25-05.00.01.tar.gz

 

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:

 

ssh user@IP_address_of_master

 

Copy the DB password:

 

cat /var/promote/credentials/db.txt
9eaa546rc418d87904f04314a

 

Run pg_restore on the promote database and use your restoration file:

 

pg_restore -c -h $(ifconfig | grep inet | head -n1 |awk '{print $2}') -d promote -p 5432 -U promote -W -v /var/promote/db-backups/postgres/promote-2018.03.25-05.00.01.tar.gz

 

Your database should now be restored!  Keep calm and Promote on!