https://community.cloudera.com/t5/Archives-of-Support-Questions/ambari-server-setup-not-updating-the-PostgreSQL-JDBC-driver/m-p/191221#M59121 <P>I've been able to upgrade the driver manually by copying over the postgresql-jdbc.jar file saved in /usr/share/java. However, the driver does not get upgraded for the directory /usr/hdp/X.X.X.X-XXXX/hive/lib directory when I run the command</P><PRE>ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql-jdbc.jar</PRE><P>Is there a step I'm missing or doing incorrectly?</P><P>PostgreSQL was upgraded from v9.1 to v9.4 and the JDBC was being upgraded to match.</P> Fri, 07 Apr 2017 03:41:23 GMT Jeff_td 2017-04-07T03:41:23Z https://community.cloudera.com/t5/Archives-of-Support-Questions/ambari-server-setup-not-updating-the-PostgreSQL-JDBC-driver/m-p/191221#M59121 <P>I've been able to upgrade the driver manually by copying over the postgresql-jdbc.jar file saved in /usr/share/java. However, the driver does not get upgraded for the directory /usr/hdp/X.X.X.X-XXXX/hive/lib directory when I run the command</P><PRE>ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql-jdbc.jar</PRE><P>Is there a step I'm missing or doing incorrectly?</P><P>PostgreSQL was upgraded from v9.1 to v9.4 and the JDBC was being upgraded to match.</P> Fri, 07 Apr 2017 03:41:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ambari-server-setup-not-updating-the-PostgreSQL-JDBC-driver/m-p/191221#M59121 Jeff_td 2017-04-07T03:41:23Z https://community.cloudera.com/t5/Archives-of-Support-Questions/ambari-server-setup-not-updating-the-PostgreSQL-JDBC-driver/m-p/191222#M59122 <P><A rel="user" href="https://community.cloudera.com/users/17180/jeffreybarr.html" nodeid="17180">@Jeffrey Barr</A> </P><P>The following steps that you performed is good and suggested as per the doc. <A href="http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.18/bk_ambari-reference/content/_using_hive_with_postgresql.html" target="_blank">http://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.18/bk_ambari-reference/content/_using_hive_with_postgresql.html</A></P><PRE>ambari-server setup --jdbc-db=postgres --jdbc-driver=/usr/share/java/postgresql94-jdbc.jar </PRE><P>.</P><P>However if you are still facing any issue then please check the output of "<STRONG>lsof</STRONG>" command to verify which JAR is being loaded by your hive.</P><PRE>lsof -p $PID | grep postgresql</PRE><P>.</P><P>Still if you find that old jar is being used then try restarting the hive and see if it works. Also perform the following steps as last option.<STRONG> </STRONG></P><P><STRONG>On the HiveServer2/Metastore Server</STRONG></P><P> - find / -name 'postgre*.jar' -ls </P><P>- Remove old postgrexxx.jar from Agent's tmp directory and /usr/hdb/&lt;version&gt;/hive/lib </P><P>- Remove old postgrexxx.jar from Agent's cache directory </P><P>- Replace /usr/hdp/&lt;version&gt;/hadoop/lib/postgresql-jdbc.jar with newer version if exists. </P><P>- Restart ambari-agent - Restart Hive (hiveserver2/metastore) from Ambari </P><P>- Run find command again to make sure the version is correct by checking the file size</P><P>.</P><P>.</P> Fri, 07 Apr 2017 10:06:59 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/ambari-server-setup-not-updating-the-PostgreSQL-JDBC-driver/m-p/191222#M59122 jsensharma 2017-04-07T10:06:59Z