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.
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
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/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.
I have tried to install the software on the server and after I choose the option of 'Join', the next step is to enter the database details and port(it prompts for 4 things) and gives an error there itself.
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.
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
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/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.
Having the exact same issue. Has anyone been able to resolve? We have had two rim nodes for quite a while, but recently trying to add a third we can't get past this same database user info screen.
