Can't delete PostgreSQL database

Owned by Mont Rothstein
Last updated: Jun 18, 2021 by Scott Friend

Problem

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 users DETAIL:  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:

SELECT * FROM pg_prepared_xacts;

To drop a specific transaction run:

ROLLBACK PREPARED '<THE GID>';

Ex: ROLLBACK PREPARED '131075_MS03ZjAwMDEzYTo0YTg5MjA5NzoxMDczMg==';



© 2023 Foray, LLC - All Rights Reserved