[pgpool-general: 3861] cannot drop database

Janusz Borkowski janusz.borkowski at infobright.com
Wed Jul 8 23:25:45 JST 2015


Hi!

I have a *single* psql client - no other sessions:

de2505=#

I try to drop database de2505:

de2505=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# drop database if exists de2505;
ERROR:  database "de2505" is being accessed by other users
DETAIL:  There is 1 other session using the database.

again:

postgres=# \c de2505;
You are now connected to database "de2505" as user "postgres".
de2505=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# drop database if exists de2505;
ERROR:  database "de2505" is being accessed by other users
DETAIL:  There are 2 other sessions using the database.

again:

de2505=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# drop database if exists de2505;
ERROR:  database "de2505" is being accessed by other users
DETAIL:  There are 3 other sessions using the database.

one more time:

postgres=# \c de2505;
You are now connected to database "de2505" as user "postgres".
de2505=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# drop database if exists de2505;
ERROR:  database "de2505" is being accessed by other users
DETAIL:  There are 4 other sessions using the database.

For me it looks that pgpool keeps connections to the database, which prevents DROP DATABASE from succeeding. The number of connections increases with each \c from the same client.

How to ensure DROP DATABASE  succeeds ?

Thanks!
JanuszB


More information about the pgpool-general mailing list