How to Change the Database Password

Customer Managed Applies to customer-managed instances of Alation

You can reset the Alation DB password as follows, replacing <new password> with a password of your choosing.

Enter the Alation shell:

sudo /etc/init.d/alation shell
sudo su alation

psql rosemeta -c "alter user alation_db with password '<new password>'"


Be careful about quotes. '<new password>'' is surrounded by single quotes: '<new password>'; the SQL text is surrounded by double quotes as shown.


The username for running queries against Alation DB is alation_db.