question Re: How to use PostgreSQL with Ambari and Ranger without errors in Namenode and Plugins in Archives of Support Questions (Read Only)

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

amcbarnett — Wed, 14 Oct 2015 06:00:53 GMT

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:

amcbarnett — Mon, 19 Aug 2019 12:58:14 GMT

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

nsabharwal — Mon, 09 Nov 2015 10:37:58 GMT