[Geoserver-devel] PROBLEMS WITH POSTGIS

GeoServer GeoServer Developer
,
1

Hi,

I am connecting geoserver 1.5.0 with PostGis 1.2.0. I create the store of data, but when I want to create a new dataset from my PostGis store (created OK), I don’t get it in the menu, and in the log appears

614669 [GRAVE] org.geotools.data.postgis.PostgisDBInfo - ERROR: function postgis_version() does not exist

Could you help me?? Thanks

–
Jose Luis Garcia

2

Jose Luis Garcia ha scritto:

Hi,

I am connecting geoserver 1.5.0 with PostGis 1.2.0. I create the store of data, but when I want to create a new dataset from my PostGis store (created OK), I don't get it in the menu, and in the log appears

614669 [GRAVE] org.geotools.data.postgis.PostgisDBInfo - ERROR: function postgis_version() does not exist

Could you help me?? Thanks

Did you enable postgis extensions in your database?
It's not sufficient to install postgis and then create a new db, you
also have to run the contents of a few files full of sql statements
to enabled it in the db.
You can find some instructions here:
http://postgis.refractions.net/docs/ch02.html#templatepostgis
(if you don't have the template, just run steps 5,6,7 of the
instructions above it).

Hope this helps
Cheers
Andrea

3

That usually means that your postgis database is not a postgis database, when you create your database in postgres make sure you create a spatial database using the postgis template

----- Original Message ----- From: "Andrea Aime" <aaime@anonymised.com>
To: "Jose Luis Garcia" <jlmonzon@anonymised.com>
Cc: <geoserver-devel@lists.sourceforge.net>
Sent: Thursday, May 24, 2007 12:19 PM
Subject: Re: [Geoserver-devel] PROBLEMS WITH POSTGIS

Jose Luis Garcia ha scritto:

Hi,

I am connecting geoserver 1.5.0 with PostGis 1.2.0. I create the store
of data, but when I want to create a new dataset from my PostGis store
(created OK), I don't get it in the menu, and in the log appears

614669 [GRAVE] org.geotools.data.postgis.PostgisDBInfo - ERROR: function
postgis_version() does not exist

Could you help me?? Thanks

Did you enable postgis extensions in your database?
It's not sufficient to install postgis and then create a new db, you
also have to run the contents of a few files full of sql statements
to enabled it in the db.
You can find some instructions here:
http://postgis.refractions.net/docs/ch02.html#templatepostgis
(if you don't have the template, just run steps 5,6,7 of the
instructions above it).

Hope this helps
Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel