max connection error

[chandang]

Hi

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?

[chaitalirs]

Hi  chandang,

Does your script connect to pgpool port or to the database port directly? 

The reason I am asking this is you have mentioned a tag  "pgpool", further investigation depends on this data.

[chandang]

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?

[chaitalirs · Accepted solution]

Hi chandang,

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.

Below is the document for pgpool details :

http://www.pgpool.net/mediawiki/index.php/Main_Page

Hope this helps. Let us know in case you have any other issues.

[chandang]

Got it. Thanks for that.