This article is half-done without your Comment! *** Please share your thoughts via Comment ***
Few weeks ago, We got an error in one of our client PostgreSQL Server. Below is an error:
psql.bin: FATAL: remaining connection slots are reserved for non-replication superuser connections
The solution of above error is also very straightforward and short. You are getting this error because your server exceeded the limit of max_connections parameter.max_connection.
The solution is:
Decrease the value of [superuser_reserved_connections] parameter:Increase the value of [max_connections] parameter:
You can find above both parameters in postgresql.conf file.
Note: After changing parameters, you must restart the PostgreSQL cluster.
Leave a Reply