how to increase postgresql max connections

[qwebnm]

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.

[rubenmarin · Accepted solution]

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-e...

[Dineshan · Accepted solution]

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

[Maria_Halley · Accepted solution]

@qwebnm

This is also mentioned in the Qlik Help

https://help.qlik.com/en-US/sense-admin/November2022/Subsystems/DeployAdministerQSE/Content/Sense_De...