andostronaut · March 3, 2025 14:08
diff --git a/docker_exec.sh b/docker_exec.sh
 docker exec -it container_name psql -U db_user -d postgres
diff --git a/init.sql b/init.sql
 revoke connect on database target_db from public;

 select pg_terminate_backend(pg_stat_activity.pid)
 from pg_stat_activity
 where pg_stat_activity.datname = 'target_db';
	revoke connect on database target_db from public;

	select pg_terminate_backend(pg_stat_activity.pid)
	from pg_stat_activity
	where pg_stat_activity.datname = 'target_db';