X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D60D85669A for ; Mon, 28 Feb 2005 05:42:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61186-04 for ; Mon, 28 Feb 2005 05:42:16 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.207]) by svr1.postgresql.org (Postfix) with ESMTP id 7EC9E5664F for ; Mon, 28 Feb 2005 05:42:15 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so812309rnf for ; Sun, 27 Feb 2005 21:42:15 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=Tc/OOal80GiEMDgmgCT0cgeorS9Igbsp9mr8u07r/3zi6C+FNjQ9NpEPJOUoJ7pohMKfFsEVdYL7nPAsS2Po6lYAz5YYBhnIw6HQR4BORIQNwO585dD8Rl8q9uXFKxrLUK1eclD+A18+lP3JZNK0pWo95iFtIOP8zUxncCuN9tk= Received: by 10.38.66.30 with SMTP id o30mr47136rna; Sun, 27 Feb 2005 21:42:15 -0800 (PST) Received: by 10.38.97.43 with HTTP; Sun, 27 Feb 2005 21:42:15 -0800 (PST) Message-ID: <674d1f8a05022721424824ac01@mail.gmail.com> Date: Mon, 28 Feb 2005 11:12:15 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: "Thomas F. O'Connell" Subject: Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users Cc: PgSQL Admin In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.062 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/324 X-Sequence-Number: 16492 Thanks a million, pkill -f 'postgres: postgres ' really helped. regards gourish On Fri, 25 Feb 2005 10:30:31 -0600, Thomas F. O'Connell wrote: > pkill -f 'postgres: postgres ' > > 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