Geoserver ERROR: function postgis_lib_version()

Question

in geoserver whene i need to creat a new data store after to creat new workspace, i have this error

Error creating data store, check the parameters. Error message: Unable to obtain connection: ERROR: function postgis_lib_version() does not exist Indice : No function matches the given name and argument types. You might need to add explicit type casts. Position : 8

i don't do any code yet , i have juste my data base in postgres — oustyle, Jul 27 '16 at 09:29

score 18 · Accepted Answer · answered Jul 28 '16 at 07:37

That error implies that you are attempting to add a PostgreSQL database rather than a PostGIS database. You need to add the PostGIS extension to the database with this command:

psql -d yourdatabase -c "CREATE EXTENSION postgis;"
psql -d yourdatabase -c "CREATE EXTENSION postgis_topology;"

This will then allow you to store geometries (and geographies) in your tables which GeoServer can then display as map layers.

Geoserver ERROR: function postgis_lib_version()

1 Answers1

Linked