|
Hi,
I’m using Geoserver Importer extension to load multiple PostGIS tables into geoserver. I definied connection to PostGIS db and it works fine. I see the list of all tables in specific schema (“data”).
When i try to load the selected table i received the following error:
java.io.IOException: Error occurred creating table
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:743)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:144)
at org.geoserver.importer.Importer.loadIntoDataStore(Importer.java:1447)
at org.geoserver.importer.Importer.doIndirectImport(Importer.java:1209)
at org.geoserver.importer.Importer.run(Importer.java:1015)
at org.geoserver.importer.Importer.runInternal(Importer.java:975)
at org.geoserver.importer.Importer$3.callInternal(Importer.java:1055)
at org.geoserver.importer.Importer$3.callInternal(Importer.java:1047)
at org.geoserver.importer.Importer$SecurityContextCopyingJob.call(Importer.java:1091)
at org.geoserver.importer.job.Job.call(Job.java:16)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for schema data
Position: 14
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:735)
... 13 more
The current user has already privilage to usage “data” schema. When I try to add this table in the standard way without using the Importer Extension, everything is ok. There are no permission errors .
|
Medium
