Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 🙂