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

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

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: 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-25 16:30:31
Message-ID: d9cf51e17973bcee0b49047396d282d0@sitening.com (view raw or flat)
Thread:
Lists: pgsql-admin
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


Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2005-02-25 16:45:39
Subject: Re: Cross tablespaces query
Previous:From: Tom LaneDate: 2005-02-25 16:02:18
Subject: Re: pg_sorttemp#####.##

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