I have a script to run which will send 800 connections at a time. I am getting max_connection alert even though the settings I have done is for 1000 connections. Isn't this strange or some other setting is blocking this?
Connect the application or your script to the pgpool port, after which you will be able to utilize the pgpool connections. However, you will have to tune the database parameters in such a way that they do not contradict.
Ohk sorry I completely forgot to mention about pgpool in the description. So there is pgpool on frontend and connections hit the database port not the pgpool. Should I change the port to pgpool,is this what is required?
Connect the application or your script to the pgpool port, after which you will be able to utilize the pgpool connections. However, you will have to tune the database parameters in such a way that they do not contradict.
.png "EDB Team Member"){kind=icon}