Skip to content

Instantly share code, notes, and snippets.

@jlsherrill

jlsherrill/change postgres user pass.sh

Forked from mccun934/change postgres user password
Last active March 16, 2018 16:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jlsherrill/e542f9d01c7f1d94459898ece25d8da3 to your computer and use it in GitHub Desktop.
Save jlsherrill/e542f9d01c7f1d94459898ece25d8da3 to your computer and use it in GitHub Desktop.
Download ZIP
change postgres user pass
Raw
change postgres user pass.sh
# EG : ALTER USER Postgres WITH PASSWORD '<newpassword>';
CP_PASS=`grep jpa.config.hibernate.connection.password /etc/candlepin/candlepin.conf | awk -F= '{print $2}'`
F_PASS=`grep password /etc/foreman/database.yml | awk -F: '{print $2}' | sed 's/"//g'`
echo "ALTER USER candlepin WITH PASSWORD '$CP_PASS';" | sudo -u postgres psql
echo "ALTER USER foreman WITH PASSWORD '$F_PASS';" | sudo -u postgres psql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment