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

Reply via email to