Page 1 of 1

can't delete database

PostPosted: Sun Jul 27, 2008 11:29 pm
by six4withafro
i'm trying to delete a database in order to make room for the new db i'll be creating by reimporting all of my hands, but i keep getting this error:
[ img ]

i was able to purge the db, so i deleted all the data and reclaimed the space, but thought i should report this.

Re: can't delete database

PostPosted: Mon Jul 28, 2008 4:09 am
by WhiteRider
You're not running an import or anything at the time, are you?

Re: can't delete database

PostPosted: Mon Jul 28, 2008 4:29 am
by keggler
make sure all any other open connections to the db are closed (other pc's, orphaned processes)...

you can also try the dropdb command from the postgres bin folder...


susan

Re: can't delete database

PostPosted: Mon Jul 28, 2008 5:40 am
by six4withafro
nothing was running at the time, and it's a single pc system. i don't know if there were any orphaned processes running though. i'll try to delete it again and see what happens.