How to use PostgreSQL with Ambari and Ranger without errors in Namenode and Plugins

[#1]

PostgreSQL is configured for Ambari, Hive and as the Ranger Audit store, instead of MySQL or Oracle.

The following errors occur upon Name node start after configuring Ranger HDFS Plugin:

1. Connection to Postgres Timeout
2. Cannot find jersey-client.jar

[#2 · Accepted solution]

• Change hadoop-env template under HDFS -> Configs -> Advanced -> Advanced hadoop-env. Add the following:

#Add libraries required by postgres
for jarFile in `ls /usr/share/java/*postgres* 2>/dev/null`
do
  JAVA_JDBC_LIBS=${JAVA_JDBC_LIBS}:$jarFile
done

• Save changes
• If you are receiving the missing jersey-client.jar file, most likely Yarn Resource Manager is not on the same node as the NameNode
• Use Ambari to move the Resource Manager to the Name Node

[#3]

Thanks @Ancil McBarnett