Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Promote Knowledge Base

Definitive answers from Promote experts.

Supporting Promote Series Part 4 - The Promote Database

Alteryx Alumni (Retired)

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.




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


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!