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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

  From Date Subject
Next Message Maritza Landsberg 2005-02-28 07:13:30 Error
Previous Message knaicker 2005-02-28 05:41:39 unsubscribe