• Blog posts

    Bio

    By David Crowther 

    Question:

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

    1.jpg

    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.

    2.jpg

    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:

Comments

0 comments

Please sign in to leave a comment.