Problem

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==';

Related articles

The content by label feature displays related articles automatically, based on labels you choose. To edit options for this feature, select the placeholder below and tap the pencil icon.