cancel
Showing results for 
Search instead for 
Did you mean: 

max connection error

SOLVED
Level 2 Adventurer

max connection error

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?
1 ACCEPTED SOLUTION

Accepted Solutions
EDB Team Member

Re: max connection error

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.

 

 

4 REPLIES
EDB Team Member

Re: max connection error

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.

Level 2 Adventurer

Re: max connection error

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?
EDB Team Member

Re: max connection error

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.

 

 

Level 2 Adventurer

Re: max connection error

Got it. Thanks for that.