PostGIS – Why Can’t I Delete a Database?

By David Crowther 

Question:

When I try to delete a PostGIS database I get the error below, what could be causing this?

Answer:

The above issue means that there is currently an open connection to the PostGIS database which is stopping the database from being deleted. This could be a user connecting and accessing a database table via a desktop GIS, or alternately it could simply be that you have a window open in PGAdmin that is accessing the database e.g. a SQL Query window.

Firstly, ensure that you check that all users are not accessing any database tables and then close all open windows in PGAdmin. If that does not resolve the issue then try force closing any connections using this SQL statement in a query window… where ‘os_zoomstack’ is your database name: