[PostgreSQL] FATAL: sorry, too many clients already connection to server

Unable to connect to PostgreSQL server: connection to server at "DB hostname" (DB IP), port DB port failed: FATAL: sorry, too many clients already connection to server at "DB hostname" (DB IP), port DB Port failed: FATAL: sorry, too many clients already

Some useful script

SELECT sum(numbackends) FROM pg_stat_database;
SELECT COUNT(*) from pg_stat_activity;
SHOW config_file;
select min_val, max_val from pg_settings where name='max_connections';
SELECT * FROM pg_stat_activity;

SELECT * FROM pg_stat_activity
order by datname
Where datname = xacthuc

Kill all other active connections to your database

Using SQL Query, run the query below:

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

or this query:

SELECT
    pg_terminate_backend(pid)
FROM
    pg_stat_get_activity(NULL::integer)
WHERE
    datid = (
        SELECT
            oid
        FROM
            pg_database
        WHERE
            datname = 'database_name');

• https://stackoverflow.com/questions/25058649/psql-fatal-too-many-connections-for-role
• https://tableplus.com/blog/2018/04/postgresql-how-to-kill-all-other-active-connection-to-database.html