topic Re: update postgres max connection in Management & Governance

update postgres max connection

aadil_madarveet — Sat, 16 Nov 2024 06:17:43 GMT

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

Re: update postgres max connection

Gysbert_Wassenaar — Wed, 20 Mar 2019 08:38:18 GMT

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

Re: update postgres max connection

aadil_madarveet — Wed, 20 Mar 2019 08:48:23 GMT

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

Re: update postgres max connection

Gysbert_Wassenaar — Wed, 20 Mar 2019 09:22:23 GMT

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

Re: update postgres max connection

aadil_madarveet — Wed, 20 Mar 2019 09:44:10 GMT

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_Deployment/Installing-Qlik-Sense-multi-node.htm

Configuring PostgreSQL multi-node connections

Re: update postgres max connection

Anonymous — Wed, 20 Mar 2019 14:49:01 GMT

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 🙂