Problem
| Info |
|---|
An error similar to the following occurs when trying to drop a PostgreSQL database.
An error has occurred:
ERROR: databasedatabase "ForayAdams" is being accessed by other users usersDETAILDETAIL: There are 3 prepared transactions using the database. |
Solution
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:
| Code Block |
|---|
SELECT * FROM pg_prepared_xacts; |
To drop a specific transaction run:
| Code Block |
|---|
ROLLBACK PREPARED '<THE GID>';
Ex:
ROLLBACK PREPARED '131075_MS03ZjAwMDEzYTo0YTg5MjA5NzoxMDczMg=='; |
...