Hello, I have a imagemosaic datastore on Geoserver, that uses a Postgres database to index the granules, with the following datastore.properties : SPI=org.geotools.data.postgis.PostgisNGDataStoreFactory host=localhost port=5432 database=geoserver schema=public user=user passwd=passwd
Loose\ bbox=true Estimated\ extends=false validate\ connections=true Connection\ timeout=10 preparedStatements=true When I try to delete the datastore with the rest API : DELETE /rest/workspaces/workspace/coveragestores/store.xml?recurse=true&purge=all I got the following error : Caused by: java.io.IOException: Failed to drop the target database at org.geotools.data.postgis.PostgisNGDataStoreFactory.dropDatabase(PostgisNGDataStoreFactory.java:401) ... 118 more Caused by: org.postgresql.util.PSQLException: ERROR: database "geoserver" is being accessed by other users I don't understand why we try to delete the whole database (even with ' purge=all '). I expected the method to remove only the table in which the index was stored. I have the same behavior with purge=metadata . Is there a way to configure the datastore to keep the database and the schema intact, and drop only the underlying table ? Kind regards, Joffrey
_______________________________________________ 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