Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Oozie db to PGSQL in Ambari install.

avatar
New Contributor

While installing Ambari on CentOS7, i was asked about the Oozie db target. I opted to use PGSQL, but that failed, since i did not have any idea what the UserName, Pwd or DBName defaulted to or where to set them. The instructions page gives not idea what to use for them.

1 ACCEPTED SOLUTION

avatar
Master Mentor

@Dave Woodruff I highly recommend using the search tool on Hortonworks Documentation page to find what you're looking for. Here's the doc that can help.

View solution in original post

4 REPLIES 4

avatar
Master Mentor

@Dave Woodruff I highly recommend using the search tool on Hortonworks Documentation page to find what you're looking for. Here's the doc that can help.

avatar
Master Mentor
@Dave Woodruff

Hi, Please see this guide http://docs.hortonworks.com/HDPDocuments/Ambari-2.1.2.0/bk_ambari_reference_guide/content/_using_ooz...

Using Oozie with PostgreSQL

To set up PostgreSQL for use with Oozie:

  1. On the Ambari Server host, stage the appropriate PostgreSQL connector for later deployment.
    1. Install the connector.

      RHEL/CentOS/Oracle Linux

      yum install postgresql-jdbc

      SLES

      zypper install -y postgresql-jdbc

      UBUNTU

      apt-get install -y postgresql-jdbc

      DEBIAN

      apt-get install -y postgresql-jdbc

    2. Confirm that .jar is in the Java share directory.

      ls /usr/share/java/postgresql-jdbc.jar

    3. Change the access mode of the .jar file to 644.

      chmod 644 /usr/share/java/postgresql-jdbc.jar

    4. Execute the following command:

      ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql-jdbc.jar

  2. 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.

avatar

This is not reqired anymore when deploying ?

oozie.service.JPAService.create.db.schema=true

avatar
Master Mentor

@Peter Bartal I would follow the documentation.