MeghaPatil Posted March 18 Share Posted March 18 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.... Quote Link to comment https://forums.phpfreaks.com/topic/327051-stuck-in-the-procedure-of-dropping-database-in-progesq/ Share on other sites More sharing options...
gizmola Posted yesterday at 06:13 PM Share Posted yesterday at 06:13 PM 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) Quote Link to comment https://forums.phpfreaks.com/topic/327051-stuck-in-the-procedure-of-dropping-database-in-progesq/#findComment-1652021 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.