Forums

FATAL: remaining connection slots are reserved for non-replication superuser connections

I think the server need to be restarted. Can you do this for me?

I set max_connections to 500;

alter system set max_connections = 500;

I noticed that there are idle connections. I set the idle_in_transaction_session_timeout but idle connections aren't automatically closed.

ALTER SYSTEM SET idle_in_transaction_session_timeout = '10min';

No problem. I have restarted your Postgres server.