Droping a database even if someone is connected - Mailing list pgsql-general

From Eric Audet
Subject Droping a database even if someone is connected
Date
Msg-id 1FE49909B982214BBF40AE6C363430BD039462@mail03.scc.ca
Whole thread Raw
Responses Re: Droping a database even if someone is connected  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general

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

pgsql-general by date:

Previous
From: Dousak "May (Phoebus Apollonus)"
Date:
Subject: Re: Function in selection?
Next
From: Dousak "May (Phoebus Apollonus)"
Date:
Subject: Re: Function in selection?