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.
I confirm, I can drop the last database used, but other unused database i can.
launch ps -awxf show 8<----- ------- -8<---- ------- ---- postgresql/ 8.3/bin/ postgres -D /var/lib/ postgresql/ 8.3/main -c config_ file=/etc/ postgresql/ 8.3/main/ postgresql. conf 8<----- ------- -8<---- ------- ----
-------
7265 ? S 0:24 /usr/lib/
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
-------
There is a transaction in IDLE, which lock the database and we can't drop it.