problems :
ERROR: source database "targetDB" is being accessed by other users
DETAIL: There are 6 other sessions using the database.
Solutions
postgres=> REVOKE CONNECT ON DATABASE targetDB FROM public;
REVOKE
postgres=> SELECT pg_terminate_backend(pg_stat_activity.pid)
postgres-> FROM pg_stat_activity
postgres-> WHERE pg_stat_activity.datname = 'targetDB';
pg_terminate_backend
----------------------
t
t
t
t
t
t
(6...
