title: ERROR 3629 --- [p-nio-80-exec-8] o.a.tomcat.jdbc.pool.ConnectionPool : Unable to create initial connections of pool
body: <p>I can not find where the error is generated although the logs are clear... Caused by: java.net.UnknownHostException: votaideasdb. So I understand who did it, but can not see what is the problem or how to solve it. (It works in my local server).</p>
  
  <p>As I look for it I saw it had to do with...</p>
  
  <ol>
  <li>Either put a PostgreSql binary jar to tomcat lib folder <a href="https://stackoverflow.com/questions/22155837/severe-unable-to-create-initial-connections-of-pool-tomcat-7-with-context-xml">I have done it</a> .</li>
  <li>Other connection problems such as: 
  
  <ul>
  <li>The PostgreSQL server being restarted (DONE)</li>
  <li>The PostgreSQL backend you were connected to being terminated (Can Navicat be connected and the connection terminated at the same time?)</li>
  <li>The PostgreSQL backend you were connected to crashing (Can Navicat be connected and the connection terminated at the same time?)</li>
  <li>Dodgy network connection (Can Navicat be connected and the connection terminated at the same time?)</li>
  <li>Badly behaved stateful firewalls (Can Navicat be connected and the connection terminated at the same time?)</li>
  <li>Idle connections timing out of the NAT connection tables of NAT firewall/routers (Can Navicat be connected and the connection terminated at the same time?)</li>
  </ul></li>
  </ol>
  
  <p>If Navicat is connecting with the same user and password, does it probe that the connection is working? It may have to do with the connection pool, but I do not see how or how to test it.</p>
  
  <pre><code>2018-01-11 13:31:16.407 ERROR 3629 --- [p-nio-80-exec-8] o.a.tomcat.jdbc.pool.ConnectionPool      : Unable to create initial connections of pool.
  org.postgresql.util.PSQLException: The connection attempt failed.
      at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:262) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
      at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
      at org.postgresql.jdbc.PgConnection.&lt;init&gt;(PgConnection.java:215) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
  
  
  
  Caused by: java.net.UnknownHostException: votaideasdb
      at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184) ~[na:1.8.0_151]
      at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:1.8.0_151]
      at java.net.Socket.connect(Socket.java:589) ~[na:1.8.0_151]
      at org.postgresql.core.PGStream.&lt;init&gt;(PGStream.java:64) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
      at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:133) ~[postgresql-9.4.1208.jre7.jar:9.4.1208.jre7]
      ... 159 common frames omitted
  </code></pre>
  
  <p>I do not know where that voteideasdb name (Caused by: java.net.UnknownHostException: votaideasdb) comes from is the database name is springboottutorial.</p>
  
  <p>These are my application.properties (that work fine in my local server)</p>
  
  <pre><code>spring.datasource.url=jdbc:postgresql://localhost:5432/springboottutorial
  spring.datasource.username=postgres
  spring.datasource.password=postgres
  spring.datasource.driverClassName=org.postgresql.Driver
  
  spring.jpa.database-platform=org.hibernate.dialect.PostgreSQLDialect
  spring.jpa.generate-ddl=true
  hibernate.postgresql.auto=create
  spring.jpa.show-sql=true
  </code></pre>
  
  <p>Thank you all for you patience with non-programmers!!!!</p>