#dropdb

[gmarshall99-blog]

Gotta drop it like it's hot! The pick, that is. (Drop C hash tag! 😂) - - - #staind #eyeswideopen #aaronlewis #mikemushok #johnnyapril #bass #ibanez #bassguitar #DropDb #ernieball #jimdunlop

[just-a-guitar-dude]

I'm debating what this will be😞 #riff #orignal #dropDb #guitar #orignal #band

[just-a-guitar-dude]

Another song that I just thought of 5 minutes ago 😆 #song #original #guitar #dropDb #band

[chaeseidloi-blog]

vlog：lovecall.jp ? アイツにＬＯＶＥＣＡＬＬ！　第二回　dropdbさん

[larsneikl-blog]

デスクトップ百景 第五十四景：ないない尽くしのデスクトップ 斉藤のり子（dropdb）

[milindshakya]

PostgreSql database dropping issue

I was involved in a case today where I had to drop a Postgresql database using the command dropdb -U database_user database but it was giving me this error, 

dropdb: database removal failed: ERROR:  database "Enter Database Name Here" is being accessed by other users.

Intially, I thought it was because i was using ipython to access the database by making some django querries, but even when stopped ipython, the particular error was still persisting.

After a bit of googling, I found out that using select * from pg_stat_activity, i can get the process ids of all the ongoing connections with the database. This was a local database, so the case of other network users accessing the database was out of question.

Next step was to kill -9 all the process ids (procpid) associated with the select * from pg_stat_activity command.

That solved the problem and I could successfully drop the database.