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

Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
Cc: PgSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users
Date: 2005-02-28 05:42:15
Message-ID: 674d1f8a05022721424824ac01@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks a million,

pkill -f 'postgres: postgres <database>'

really helped. 

regards
gourish




On Fri, 25 Feb 2005 10:30:31 -0600, Thomas F. O'Connell
<tfo(at)sitening(dot)com> wrote:
> pkill -f 'postgres: postgres <database>'
> 
> Much cleaner than the previous recipe for those with pkill.
> 
> -tfo
> 
> --
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
> http://www.sitening.com/
> 110 30th Avenue North, Suite 6
> Nashville, TN 37203-6320
> 615-260-0005
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 


-- 
Best,
Gourish Singbal

In response to

pgsql-admin by date

Next:From: Maritza LandsbergDate: 2005-02-28 07:13:30
Subject: Error
Previous:From: knaickerDate: 2005-02-28 05:41:39
Subject: unsubscribe

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