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!