RDS backup database with template

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 rows)

postgres=> create database backutargetDB_oct template targetDB owner odoo;

CREATE DATABASE

postgres=> create database eisr template targetDB owner odoo;

CREATE DATABASE

postgres=> GRANT CONNECT ON DATABASE solusi TO public;

GRANT

..show all:.

.

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 rows)

postgres=> create database backutargetDB_oct template targetDB owner odoo;

CREATE DATABASE

postgres=> create database eisr template targetDB owner odoo;

CREATE DATABASE

postgres=> GRANT CONNECT ON DATABASE solusi TO public;

GRANT