How many times have we faced this kind of message...
DETAIL: There is 1 other session using the database.
... and had no idea what and who is connected to our db? To get this information, just open up your SQL console and type in
SELECT * FROM pg_stat_activity;
This should result in following listing being displayed