Support Questions
Find answers, ask questions, and share your expertise

Connection failed during the hive metastore integration with existing postgres in ambari

Explorer

Connection failed during the hive metastore integration with existing postgres in ambari


downloaded and installed the jdbc driver for postgres using below commands

path : /usr/share/java/

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

after success message , created the db , uder and pwd using below commands


echo "CREATE DATABASE dt_dev;" | psql -U postgres

echo "CREATE USER dma WITH PASSWORD 'password';" | psql -U postgres

echo "GRANT ALL PRIVILEGES ON DATABASE dt_dev TO dma;" | psql -U postgres


then restarted the postgres services

note; updated the /pg_hba.conf file with below command

local all dma md5


all all this still my connection is getting failed duirng HDP installation


0 REPLIES 0