Postgres Pro
Downloads
Home   >   mailing lists

Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users - Mailing list pgsql-admin

From Thomas F.O'Connell
Subject Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users
Date
Msg-id d9cf51e17973bcee0b49047396d282d0@sitening.com
Whole thread Raw
In response to dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users  (Gourish Singbal <gourish@gmail.com>)
Responses Re: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users  (Gourish Singbal <gourish@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_sorttemp#####.##
Next
From: Peter Eisentraut
Date:
Subject: Re: Cross tablespaces query