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

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2005-02-25 16:45:39 Re: Cross tablespaces query
Previous Message Tom Lane 2005-02-25 16:02:18 Re: pg_sorttemp#####.##