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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])