Configure Oozie to use PostgreSQL

Question

How to configure Oozie to use PostgreSQL? I have installed and configured Oozie and PostgreSQL separately. I need to know what properties to add to make Oozie use PostgreSQL. Thanks.

Answer 1

To configure Oozie to use PostgreSQL, add the following property to in the oozie-site.xml:

<property>
        <name>oozie.service.JPAService.jdbc.driver</name>
        <value>org.postgresql.Driver</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.url</name>
        <value>jdbc:postgresql://localhost:5432/oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.username</name>
        <value>oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.password</name>
        <value>oozie</value>
    </property>