Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi, the change in postglesql.conf should be enough, after the changes you need to restart the repository database service.
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
This is also mentioned in the Qlik Help
Hi, the change in postglesql.conf should be enough, after the changes you need to restart the repository database service.
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
This is also mentioned in the Qlik Help