Knowledgebase: Support
Can't delete PostgreSQL database
Posted by Mont Rothstein on 28 January 2014 08:25 AM

An error similar to the following occurs when trying to drop a PostgreSQL database.

An error has occurred:
ERROR:  database "ForayAdams" is being accessed by other usersDETAIL:  There are 3 prepared transactions using the database.

Prepared transactions are in-process transactions.  If you are dropping the database then you most likely don't care about them.  To view all prepared transactions run:

SELECT * FROM pg_prepared_xacts;

To drop a specific transaction run:

ROLLBACK PREPARED '<THE GID>';

Ex:

ROLLBACK PREPARED '131075_MS03ZjAwMDEzYTo0YTg5MjA5NzoxMDczMg==';



Comments (0)