To set up PostgreSQL for use with Oozie:
Create a user for Oozie and grant it permissions.
Using the PostgreSQL database admin utility:
echo "CREATE DATABASE $OOZIEDATABASE;" | psql -U postgres echo "CREATE USER $OOZIEUSER WITH PASSWORD '$OOZIEPASSWORD';" | psql -U postgres echo "GRANT ALL PRIVILEGES ON DATABASE $OOZIEDATABASE TO $OOZIEUSER;" | psql -U postgres
Where
$OOZIEUSERis the Oozie user name,$OOZIEPASSWORDis the Oozie user password and$OOZIEDATABASEis the Hive database name.
