Re: Dropping a DB while it is in use?

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: "Chad N(dot) Tindel" <chad(at)tindel(dot)net>
Subject: Re: Dropping a DB while it is in use?
Date: 2004-01-05 01:32:31
Message-ID: 3FF8BEAF.4050302@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Chad N. Tindel wrote:

> 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.

You can do a kill -INT to backend that are managing the connection.

Regards
Gaeatano Mendola

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Glaesemann 2004-01-05 06:01:04 Re: [HACKERS] IEEE 754
Previous Message Bruce Momjian 2004-01-05 00:51:13 Re: [HACKERS] IEEE 754