You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Ruhua Jiang <ru...@gmail.com> on 2016/04/05 23:13:09 UTC

Hive with PostgreSQL, PostgreSQL can't start

Hi 

I am using PostgreSQL as hive metastore. When I try to restart postgre service, I see following errors. 

Tue Apr  5 20:50:47 UTC 2016 : starting process == postgresql   ==
2016-04-05 20:50:47.956 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls1. Was tablespaces.done deleted?
2016-04-05 20:50:47.956 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls2. Was tablespaces.done deleted?
2016-04-05 20:50:47.956 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls3. Was tablespaces.done deleted?
2016-04-05 20:50:47.956 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls4. Was tablespaces.done deleted?
2016-04-05 20:50:47.956 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls5. Was tablespaces.done deleted?
2016-04-05 20:50:47.956 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls6. Was tablespaces.done deleted?
2016-04-05 20:50:47.957 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls7. Was tablespaces.done deleted?
2016-04-05 20:50:47.957 PG_9.1_201105231 exists in /somepath/postgresql9.1/hive/tbls8. Was tablespaces.done deleted?

PostgreSQL seems going into a bad state.  Anyone has some idea?  Probably is a postgresql question, but still want to give a shot see if any hive users see this before. Thanks


Ruhua