topic Re: how to increase postgresql max connections in Management & Governance

how to increase postgresql max connections

qwebnm — Fri, 15 Nov 2024 22:19:16 GMT

I want to increase the maximum number of postgresql connections.
I searched and found that there was a change to the max_connections value in postgresql.conf.
1) The max_connections of C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.x\ is 500.

How should I modify this value?

2) The values of Value1 and Value2 are different. Do I have to match them too?

Please answer.

Value 1)

location : C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.x\의 max_connections

Value 2)

location : /pgdata/postgresql.conf

Thanks & Regards.

Re: how to increase postgresql max connections

rubenmarin — Tue, 29 Nov 2022 10:09:13 GMT

Hi, the change in postglesql.conf should be enough, after the changes you need to restart the repository database service.

https://community.qlik.com/t5/Official-Support-Articles/PostgreSQL-postgresql-conf-and-pg-hba-conf-explained/ta-p/1713744

Re: how to increase postgresql max connections

Dineshan — Thu, 01 Dec 2022 20:31:29 GMT

Hi @qwebnm,

I found this link that might with your question as well.

https://stackoverflow.com/questions/30778015/how-to-increase-the-max-connections-in-postgres

Thank you,

Dinesh

Re: how to increase postgresql max connections

Maria_Halley — Fri, 02 Dec 2022 14:12:31 GMT

@qwebnm

This is also mentioned in the Qlik Help

https://help.qlik.com/en-US/sense-admin/November2022/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-configuring-postgresql.htm