By default, the Postgres database installed by the Qlik Sense installer will only listen to requests from the local machine.
This may need to be configured to allow database access to the rim nodes.
- If you installed a local database, the files are located in %ProgramData%\Qlik\Sense\Repository\PostgreSQL\\
- If you set up a dedicated Postgres server, the files are located in %ProgramFiles%\PostgreSQL\9.3\data.
Note: June 2017 and later versions use PostgreSQL 9.6.
Do the following:
- Copy the file postgresql.conf to another folder and open it in a text editor.
- Locate the listen_addresses setting, uncomment it by removing the # symbol at the start of the line, and then set it to *:
listen_addresses = '*'
- Set the maximum number of database connections to 100 x number of nodes in the Qlik Sense site:
max_connections = 200 # this example is for a site with 2 nodes
- Save the postgresql.conf file and copy it, replacing the existing file.
- Copy the file pg_hba.conf to another folder and open it in a text editor.
- Locate the following line:
host all all 127.0.0.1/32 md5
This line determines which servers can access the server that the repository database runs on. The default setting, 127.0.0.1/32, only allows localhost to access the database.
- Add a subnet specification that covers the IP addresses of all nodes in your site can appear as such:
# IPv4 local connections:
host all all 0.0.0.0/0 md5
# IPv6 local connections:
host all all ::/0 md5
- Or add one row for each node, using /32 as suffix for each address, or add a subnet that covers all addresses using, for example, /24 as suffix.
- Note: If you do not know which addresses to add, check with your system administrator. Qlik Sense 3.1 SR2 Shared Persistence | 24
- Save the pg_hba.conf file and copy it, replacing the existing file.
- If you installed a local database, restart Qlik Sense Repository Database. If you set up a dedicated Postgres server, restart postgresql service from Windows Services.