How to close an active connection in the IriusRisk postgresql database

If for any reason, you need to close the active connections to your IriusRisk on-prem database, you can launch the following command:

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'iriusprod' ;

Or directly:

sudo -u postgres psql -c "SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'iriusprod' ;" 2> /dev/null