I think this may be a PostgreSQL permissions problem in your database.
Geoserver needs to be able to 'SELECT * FROM' the 'geometry_columns' view in
your database. So you need to make sure that the user/role that Geoserver is
using for authentication has the ability to do that. If that is not the
problem, then you can check the settings in pg_hba.conf etc..
-Thayer
On Friday, July 9, 2021, 10:45:55 AM EDT, celati Laurent
wrote:
Good afternoon,I succeed in create a postgis data store with geoserver. When i
try to add new layer, i can see my postgis tables. But when i try to publish
the tables, i have an error message :My geometry column, is "geom" for
information. Below a extract of the error message :
Caused by: org.postgresql.util.PSQLException: ERREUR: la relation «
geometry_columns » does not exist Position : 18 at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) at
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at
org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310) at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296) at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273) at
org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:226) at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.data.postgis.PostGISDialect.lookupGeometryType(PostGISDialect.java:637)
at
org.geotools.data.postgis.PostGISDialect.getMappingInternal(PostGISDialect.java:582)
at
org.geotools.data.postgis.PostGISDialect.getMapping(PostGISDialect.java:555) at
org.geotools.jdbc.JDBCFeatureSource.getColumnMetadata(JDBCFeatureSource.java:811)
at
org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:192)
... 129 more
Thanks a lot
___
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
___
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users