Using Oozie with PostgreSQL - Hortonworks Data Platform

Apache Ambari Administration

Also available as:

PDF

Contents

loading table of contents...

Using Oozie with PostgreSQL

To set up PostgreSQL for use with Oozie:

Steps

On the Ambari Server host, stage the appropriate PostgreSQL connector for later deployment.
1. Download the PostgreSQL JDBC Driver from PostgreSQL.
2. On the Ambari Server host run:
```
ambari-server setup --jdbc-db=postgres --jdbc-driver=/path/to/postgres/postgresql.jar
```
3. Confirm that .jar is in the Java share directory.
```
ls /usr/share/java/postgresql-jdbc.jar
```
4. Change the access mode of the .jar file to 644.
```
chmod 644 /usr/share/java/postgresql-jdbc.jar
```
5. Execute the following command:
```
ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql-jdbc.jar
```
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 <OOZIEUSER> is the Oozie user name, <OOZIEPASSWORD> is the Oozie user password and <OOZIEDATABASE> is the Oozie database name.