How to Change the Database Password

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>'"

Note

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

Note

The username for running queries against Alation DB is alation_db.