ERROR: database "name" is being accessed by other users DETAIL: There are 1 other session(s) using the database.

SevenAteAnthony
SevenAteAnthony used Ask the Experts™
on
Hi Experts,

Thanks for reading. I'm completely new to PostgreSQL and need to drop some databases I've created, however, I cannot. I'm using Navicat and pgAdmin3 to try and both times I cannot. Each time I click the database it seems to establish a connection but I have to click it to get the delete right-click option. I cannot figure out for the life of me nor on Google how to delete them. How can I do this?

Thank you!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use command line tool
dropdb DBNAME

Author

Commented:
Thanks, earthman2. What is this command line tool you speak of?
dropdb.exe

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial