If you are using Postgresql 9 then as a heads up, I had to upgrade the
“postgresql jdbc jar” from 8.x to the 9.3 version in the GeoServer WEB-INF/lib
directory in order to get PG Raster working with ImageMosaic JDBC plugin.
I replaced “postgresql-8.4-701.jdbc3.jar” with “postgresql-9.3-1101-jdbc4.jar”.
I’m using same GeoServer and PostGIS version as you are.
--Steve
From: Stefano Iacovella [mailto:[email protected]]
Sent: Friday, July 25, 2014 2:12 PM
To: Christian Mueller
Cc: geoserver-users
Subject: Re: [Geoserver-users] ImageMosaic JDBC plugin fails with GeoServer
2.5.1 and PostGIS 2.1.3
Hi Christian,
while reading the tutorial you suggested me:
This is the way you have to prepare your image data:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html
A warning captured my attention:
" For Postgis JDBC drivers < version 9 it is necessary to set a property in
the database:
ALTER DATABASE dbname SET bytea_output TO ‘escape’ "
Indeed I am using JDBC driver contained in the GeoServer war and they are an
8.x release, more exactly this one:
postgresql-8.4-701.jdbc3.jar
So I tried the fix suggested:
ALTER DATABASE dbname SET bytea_output TO ‘escape’
This solved my issue.
I successfully added the coverages created according to the detailed
instruction from here:
http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html
(by the way I think you are the author of it, aren't you?)
Thank you very much for pointing me to that tutorial!
Now I am curious about using the plugin with PostGIS Raster. I will try and, if
I can abuse of your expertise and kindness, will report here.
Import your raster data as described here
http://postgis.refractions.net/docs/using_raster.xml.html
Just a quick question about this reference. I have already used raster2psql to
import raster in PostGIS, but it seems to me that preparing tiles previously
with gdal_retile may be needless as among raster2psql option you can specify
tiles size and pyramids levels, am I misunderstanding it?
Cheers,
Stefano
---------------------------------------------------
41.95581N 12.52854E
http://www.linkedin.com/in/stefanoiacovella
http://twitter.com/#!/Iacovellas
------------------------------------------------------------------------------
Want fast and easy access to all the code in your enterprise? Index and
search up to 200,000 lines of code with a free copy of Black Duck
Code Sight - the same software that powers the world's largest code
search on Ohloh, the Black Duck Open Hub! Try it now.
http://p.sf.net/sfu/bds
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
