update postgres max connection

[aadil_madarveet]

Hi All,

In a multi-node environment, when adding additional nodes, how do we update the max connection settings to the postgres db.

I keep getting errors as "too many connections" in the repository logs.

Thanks,
Aadil

[Gysbert_Wassenaar · Accepted solution]

See the postgresql.conf section of this help page: https://help.qlik.com/en-US/sense/February2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense...

[aadil_madarveet]

Thanks for the answer.
This page shows configuration options for a standalone installation of postgres.
But I am using the bundled one that comes with QlikSense installation.
And i cant seem to be able to find the folder and the file that the documentation explains.

Thanks,
Aadil

[Gysbert_Wassenaar]

Postgresql is postgresql. It doesn't matter if you're using a single node or a multinode installation. There will always be a postgresql repository database. If you're not using a separate postgresql installation, but the default installation done by Qlik Sense then you can find the postgresql files in C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6

[aadil_madarveet]

Agree. I didnt mean to say that the installations or different. I just meant that the bundled one is in use.

Anyways. This helped me. Should have looked harder before posting. My bad.

https://help.qlik.com/en-US/sense/February2019/Subsystems/PlanningQlikSenseDeployments/Content/Sense...

Configuring PostgreSQL multi-node connections

[Anonymous]

Feel free to check out this article as it may help you with this precisely:

https://support.qlik.com/articles/000044788

Excessive connections could also mean TCP connections exceeding the OS limitations. Please reference this article that could possibly account and remedy that scenario. 

https://support.qlik.com/articles/000028606

Good luck 🙂