Comment 4 for bug 307069

Revision history for this message
Christophe CHAUVET (christophe-chauvet) wrote :

I confirm, I can drop the last database used, but other unused database i can.

launch ps -awxf show
-------8<-------------8<---------------
 7265 ? S 0:24 /usr/lib/postgresql/8.3/bin/postgres -D /var/lib/postgresql/8.3/main -c config_file=/etc/postgresql/8.3/main/postgresql.conf
 7268 ? Ss 0:55 \_ postgres: writer process
 7269 ? Ss 0:45 \_ postgres: wal writer process
 7270 ? Ss 1:05 \_ postgres: autovacuum launcher process
 7271 ? Ss 2:31 \_ postgres: stats collector process
 8062 ? Ss 0:00 \_ postgres: terp50 testpsyco 127.0.0.1(37326) idle in transaction
 8066 ? Ss 0:00 \_ postgres: terp50 testpsyco 127.0.0.1(37329) idle
-------8<-------------8<---------------
There is a transaction in IDLE, which lock the database and we can't drop it.