dropdb: database removal failed: active sessions

From: JD Wong <jdmswong(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: dropdb: database removal failed: active sessions
Date: 2011-08-29 19:22:43
Message-ID: CAGuHHn-KJru-hi-6ZHdVdJgYBEJdre9fwn0CWCXKwmwy9Zt3Jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I cannot dropdb. Postgres throws me:
dropdb: database removal failed: ERROR: database "database1" is being
accessed by other users
DETAIL: There are 1 other session(s) using the database.

the "select datname,current_query,query_start from pg_stat_activity ;" query
gives me:

datname |
current_query |
query_start
-------------------------+--------------------------------------------------------------------------------------------------------------------------+-------------------------------
database2 | CREATE INDEX location_object_bioseg ON location
USING gist (locatedonid, bioseg_create(intermine_start, intermine_end)); |
2011-08-29 14:43:40.856594-04
database3 | <IDLE>
|
2011-08-29 15:08:17.469927-04
database4 | <IDLE>
|
2011-08-29 15:07:09.484543-04
database3 | <IDLE>
|
2011-08-29 15:07:09.901601-04
database2 | select datname,current_query,query_start from
pg_stat_activity ; |
2011-08-29 15:12:39.811168-04
database3 | <IDLE>
|
2011-08-29 15:08:17.476254-04
database3 | <IDLE>
|
2011-08-29 15:07:10.422579-04
database4 | <IDLE>
|
2011-08-29 15:07:10.515946-04
database1 | <IDLE>
|
2011-08-29 15:07:31.423596-04

Is the drop being prevented by the active query from database2? If not how
can I kill the <IDLE> query that must be preventing deletion.

Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2011-08-29 19:42:17 Re: passing cursors from one PL function to another
Previous Message Pavel Stehule 2011-08-29 19:12:35 Re: passing cursors from one PL function to another