title: Hive Metastore Configurations PostgreSQL
body: <p>When I start Hive metastore service, my command line says: "Starting Hive Metastore Server" and nothing further. It doesn't actually start server, neither does it throws any error messages</p>
  
  <p>Hive : 1.2.1
  Hadoop : 2.7.1
  Postgres: 9.3.8</p>
  
  <p>hive-site.xml</p>
  
  <pre><code>&lt;configuration&gt;
      &lt;property&gt;
          &lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;
          &lt;value&gt;jdbc:postgresql://localhost:5432/metastore&lt;/value&gt;
      &lt;/property&gt;
  
      &lt;property&gt;
          &lt;name&gt;javax.jdo.option.ConnectionDriverName&lt;/name&gt;
          &lt;value&gt;org.postgresql.Driver&lt;/value&gt;
      &lt;/property&gt;
  
      &lt;property&gt;
          &lt;name&gt;javax.jdo.option.ConnectionUserName&lt;/name&gt;
          &lt;value&gt;hiveuser&lt;/value&gt;
      &lt;/property&gt;
  
      &lt;property&gt;
          &lt;name&gt;javax.jdo.option.ConnectionPassword&lt;/name&gt;
          &lt;value&gt;*****&lt;/value&gt;
      &lt;/property&gt;
  
      &lt;property&gt;
          &lt;name&gt;org.jpox.autoCreateSchema&lt;/name&gt;
          &lt;value&gt;true&lt;/value&gt;
      &lt;/property&gt;
  
  &lt;/configuration&gt;
  </code></pre>
  
  <p>[metastore is actual database created in PostgresSQL, and I can access it using: psql -U hiveuser -d metastore]</p>