How To Resolve/Fix Error Database Is Being Accessed By Other Users Other...

Only 3.9% of viewers are subscribing to my channel 😓.

I request you to please give click on Subscribe button.

It really helps me grow 😢.

ERROR:  database "dvdrental" is being accessed by other users

DETAIL:  There is 1 other session using the database.

REVOKE CONNECT ON DATABASE dvdrental from public;  

SELECT pg_terminate_backend(pg_stat_activity.pid) 

FROM pg_stat_activity  

WHERE pg_stat_activity.datname = 'dvdrental';

drop database dvdrental;

How To Resolve/Fix Error Database Is Being Accessed By Other Users Other Session Using The Database