From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Unable to drop DB in latest CVS version |
Date: | 2004-09-21 22:01:58 |
Message-ID: | 200409211601.58898.pgsql@bluepolka.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to unsuccessfully to drop a database using the latest
CVS code for 8.0.0, getting the following error:
ERROR: cannot drop the currently open database
So I must have a connection open, right? So I look for
connections with the command I use on 7.3.4 but see nothing:
SELECT pg_stat_get_backend_pid(S.backendid) AS pid,
db.datname AS database, dbu.usename AS user,
pg_stat_get_backend_activity(S.backendid) AS query
FROM pg_user dbu,
(SELECT pg_stat_get_backend_idset() AS backendid) AS S,
pg_database db
WHERE db.oid = pg_stat_get_backend_dbid(S.backendid)
AND dbu.usesysid = pg_stat_get_backend_userid(S.backendid);
pid | database | user | query
-----+----------+------+---------
(0 rows)
So I look at the process table listing:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
db2dba 1039 0.0 0.2 114604 3388 pts/3 S 13:49 0:00 postmaster -D /users/db2dba/dbclusters/db2/postgresql-8.0.0beta2/data -i -p 9802
db2dba 1042 0.0 0.1 6720 1544 pts/3 S 13:49 0:00 postgres: logger process
db2dba 1044 0.0 0.5 114740 6836 pts/3 S 13:49 0:00 postgres: writer process
db2dba 1045 0.0 0.2 7736 2592 pts/3 S 13:49 0:00 postgres: stats buffer process
db2dba 1046 0.0 0.1 7044 1856 pts/3 S 13:49 0:00 postgres: stats collector process
Sure don't see anything open. I can stop/restart to get around it,
but wondering what is going on?
Ed
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2004-09-21 22:03:58 | Re: Unable to drop DB in latest CVS version |
Previous Message | Thomas F.O'Connell | 2004-09-21 21:17:12 | Re: the current scoop on ilike and indexes |