I never have this issue with MySQL but PostgreSQL is ALWAYS a pain when trying to do any kind of maintenance.
So I am trying to truncate and load new data into databases on PostgreSQL server but there are usually active connections and this messes up things. There is also one particular database I need to drop and create and current active doesn't allow me to drop it.
All these are setup in a script that should run.
My issue is active connections is killing me and not letting the script work. Need help on how to overcome this problem.
Do I lock connections to the DB or block connections? How do I do this? Not very familiar with PostgreSQL as I am with MySQL.