CDH6.0.0 Postgresql Database setup script

cdh6-postgresql.sh

export PG_PASSWD="USE_UR_PASSWD"
for db_name in scm amon rman hue metastore sentry nav navms oozie; do sudo -u postgres psql -c "CREATE ROLE $db_name LOGIN PASSWORD '$PG_PASSWD';"; sudo -u postgres psql -c "CREATE DATABASE $db_name OWNER $db_name ENCODING 'UTF8';"; done
sudo -u postgres psql -c "SELECT rolname FROM pg_roles;" && sudo -u postgres psql -c "\l"
for db_name in metastore oozie; do sudo -u postgres psql -c "ALTER DATABASE $db_name SET standard_conforming_strings=off;"; done
sudo /opt/cloudera/cm/schema/scm_prepare_database.sh postgresql scm scm $DB_PASSWD

Run "psql -dscm -Uscm -h 127.0.0.1 -l" to check if password is correct.

sudo cat /var/lib/cloudera-scm-server-db/data/generated_password.txt
psql -p 7432 -h localhost -U cloudera-scm -d postgres

sudo find /usr -name "*.pyc" -delete

Visualization Server Environment Advanced Configuration Snippet (Safety Valve)

VENV_PATH=AVOID_SYSTEM_PYTHON

ln -s /opt/cloudera/parcels/CDH-6.0.0-1.cdh6.0.0.p0.537114/jars/logredactor-2.0.6.jar /opt/cloudera/parcels/CDH/lib/spark/jars/logredactor-2.0.6.jar

cd /opt/cloudera/parcels/ARCADIAENTERPRISE-4.3.0.0-1531519736.cdh5/lib/arcviz/
./arcviz util user --list
./arcviz createsuperuser
./arcviz util user --username bduser --firstname admin --lastname admin --email zhongyue.nah@intel.com --password admin --group default