Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Michael GlaesemannDate: 2004-01-05 06:01:04
Subject: Re: [HACKERS] IEEE 754
Previous:From: Bruce MomjianDate: 2004-01-05 00:51:13
Subject: Re: [HACKERS] IEEE 754

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group