Dropping a DB while it is in use?

From: "Chad N(dot) Tindel" <chad(at)tindel(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Dropping a DB while it is in use?
Date: 2003-12-29 00:52:44
Message-ID: 20031229005244.GA59513@calma.pair.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there a way to kill all the connections to a DB so that it can safely
be dropped? Given that connections to a DB can come from any number of clients,
the only way I've found to do this is to shutdown postgres, which is clearly
an unacceptable solution because it stops access to the other 50 or so databases
that are being used on the system.

Thanks,

Chad

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Fabiàn R. Breschi 2003-12-29 14:54:52 Solaris 9 + 7.4: error in initdb.
Previous Message Сизых Павел Леонидович 2003-12-29 00:43:19 7.1.3 -> 7.3.2