max connection error

SOLVED
Highlighted
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?

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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.

 

 

View solution in original post

4 REPLIES 4
Highlighted
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.

Highlighted
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?
Highlighted
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.

 

 

View solution in original post

Highlighted
Level 2 Adventurer

Re: max connection error

Got it. Thanks for that.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks