Stuck in the procedure of dropping database in progeSQ....

[MeghaPatil]

I'm trying to drop a PostgreSQL database using the DROP DATABASE mydb command, but I getting this error:

Please help me with any guidance....

[gizmola]

When you connect to postgresql you specify a database.  If you are connecting to the database you are trying to drop, you will be blocking your ability to drop it.

Make sure you connect to the postgres database.

If that is not the issue, and you are not connecting to mydb,  you should be able to drop the database regardless of any other existing connections to it, using:

drop database mydb with (force)

[MeghaPatil]

You gave a solution, and I tried it but again got stuck .... that's why I did a search and got lots of guides to solve my issue... I read https://www.dedicatedcore.com/blog/drop-postgresql-database/ this blog. they also gave lots of solutions, but no one can solve my problem... Pls share any other guide pls.

[gizmola]

What specific commands are you running, and what specific error message(s) are you receiving?