Droping a database even if someone is connected

From: Eric Audet <eaudet(at)scc(dot)ca>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Droping a database even if someone is connected
Date: 2003-03-13 19:19:39
Message-ID: 1FE49909B982214BBF40AE6C363430BD039462@mail03.scc.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Hauser 2003-03-13 19:28:15 timestamp 'default' question
Previous Message Dousak May (Phoebus Apollonus) 2003-03-13 19:19:24 Re: Function in selection?