[postgis-users] pgraster on geoserver working?

[Andrew Babiy]

>I followed this manual and got to a point where geoserver tries to
>populate the store but then I get:
>  ERROR [org.geotools.gce.imagemosaic.jdbc] - Unknown WKB type 48


This is Postgresql 9.0 feature(issue?), related with default 'hex'
representation type of bytea
It's a result of changing the default escaping from bytea to hex in
PostgreSQL 9.0? For more details see:

http://developer.postgresql.org/pgdocs/postgres/datatype-binary.html

http://developer.postgresql.org/pgdocs/postgres/runtime-config-client.html#GUC-BYTEA-OUTPUT

Changing the bytea_output GUC back to escape fix this.

Or, you can just change bytea_output in postgresql.conf