Is there a way to drop a database even if someone is connected to it?
I use a perl script that
1) drop the database, (dropdb)
2) create a new database, (createdb)
3) restore a database from a dump (psql databasename <dumpfile)
When the drop does not work, everything else fails!
Thanks in advance
Eric