When you try to delete your PostgreSQL database you may get an error:
If you're sure there's no other user connected, then it may be because PostgreSQL has a pending prepared transaction that's never been committed or rolled back, which should never happen except if the database is shut down in an unclean manner (machine crash). To check for this, run:
If you get a result, then for each transaction gid you must execute a ROLLBACK from the database having the problem:
For instance:
If you have lots of transactions you can run this psql scripts:
Labels:
None