Reply
Highlighted
Explorer
Posts: 26
Registered: ‎12-08-2016

JDBC url = jdbc:postgresql://myhost.com:7432/hive, username = hive. Terminating connection pool

Hi,

 

The cluster is off due to unexpected power failure which happened this morning.  I started the cluster after the power is back but Hive metastore is not able to connect with Postgresql. Can someone let me know why?

 

 

JDBC url = jdbc:postgresql://master1.rbi.com:7432/hive, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
org.postgresql.util.PSQLException: FATAL: the database system is shutting down

Caused by: org.postgresql.util.PSQLException: FATAL: the database system is shutting down

Thanks.

Contributor
Posts: 42
Registered: ‎05-12-2016

Re: JDBC url = jdbc:postgresql://myhost.com:7432/hive, username = hive. Terminating connection pool

Do you keep all databases in posgresql? Or just hive metastore?
Explorer
Posts: 26
Registered: ‎12-08-2016

Re: JDBC url = jdbc:postgresql://myhost.com:7432/hive, username = hive. Terminating connection pool

The issue is solved after restarting the posgresql
Announcements