Automatically reload DB nightly
In a same context, I was prefering to change the password of the applicative login, during the drop/restoration process.
Is it possible for you?


  Make a query to list active connection from pg_stat_activity table to identify the culprit(s).


Hope this helps,
Thomas