On 08/29/11 12:22 PM, JD Wong wrote:
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
-------------------------+--------------------------------------------------------------------------------------------------------------------------+-------------------------------
...
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.
any connection to the database, even idle, will prevent a drop database.
try...
select pg_terminate_backend(procpid) from pg_stat_activity where
datname = 'database1';
that will snuff those processes. then you can drop the database,
assuming the clients don't immediately reconnect.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
