[Geoserver-users] Could not list layers for this store (JDBC Image Mosaic)

[David H. II <dah...@um...>]

Hello,

I am trying to build an app that utilizes raster files that I have ingested
into my PostgreSQL/PostGIS database. The error occurs when trying to make
the PostGIS raster data store. The error on the web interface says "Could
not list layers for this store, an error occurred retrieving them: Failed
to create reader from file:glc.postgis.xml and hints null".

However the geoserver log reports a connection error.
2015-06-29 09:02:30,681 WARN [data.jdbc] - Could not acquire A BDCP
connection pool.:org.geotools.data.DataSourceException: Connection pool
improperly set up: Cannot create PoolableConnectionFactory (Connection
refused. Check that the hostname and port are correct and that the
postmaster is accepting TCP/IP connections.)

What is wrong?

I know that I have the connection xml defined properly. I am following the
following documentation.
http://docs.geoserver.org/2.5.x/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html

<connect>
<dstype value="DBCP"/>
<username value="user"/>
<password value="######"/>
<jdbcUrl value="jdbc:postgresql://host:port/database"/>
<driverClassName value="org.postgresql.Driver"/>
<maxActive value="10"/>
<maxIdle value="0"/>
</connect>


-- 
David Haynes, Ph.D.
Research Associate Terra Populus
Minnesota Population Center
www.terrapop.org