Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jul 25, 2023 6:37:22 AM
Jun 4, 2018 2:03:04 PM
It is important to understand the options which PostgreSQL uses to allow connectivity. These principles are valid no matter whether you are using the Qlik Sense Repository Database service to host the database or using a standalone PostgreSQL instance. The two key files which PostgreSQL uses to define who can connect, how they connect, where they can connect from, and how many connections are allowed are:
For bundled PostgreSQL instances, the files are located in:
C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\x.x
If you have unbundled PostgreSQL using the Qlik PostgreSQL installer (QPI), the default location is:
C:\Program Files\PostgreSQL\xx\data
For any other standalone PostgreSQL instances, consulting with your database admin to locate the data directory.
Note: Any changes to these files will require a restart of the Qlik Sense Repository Database or PostgreSQL.
Note: Any lines prefixed with a # are commented out and not active.
In the postgresql.conf, in a basic Qlik Sense configuration, there are two key configuration options which are important:
Where these lines are can vary but an expected single node Qlik Sense site would look like this:
listen_addresses = '*' max_connections = 100
The pg_hba.conf file defines a variety of aspects:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::/0 md5 # Allow replication connections from localhost, by a user with the # replication privilege. #host replication postgres 127.0.0.1/32 md5 #host replication postgres ::1/128 md5 host all all 0.0.0.0/0 md5
In this example pg_hba.conf file there two active lines. The first line specifies that all users can connect to all databases from the local loopback IP using MD5 authentication (host all all 127.0.0.1/32 md5). The second line specifies that all users can connect to all databases from any valid IPv4 address using MD5 authenication (host all all 0.0.0.0/0 md5)
Please review our help for references to more sophisticated configurations where specific IP addresses or IP address ranges are covered.
To recap, when ensuring connectivity in a Qlik Sense Shared Persistence environment, especially a multi-node site, the core configurations which are needed are:
Hi @Sonja_Bauernfeind ,
We rollback to Feb 2022, and this is the current configuration since May 2022.
Qlik Sense is installed in the E: drive, the files are in C?
Regarding the error I had, I think was caused by the format of the service account (lower case), I will give a second try next weekend
Hello @pasgalbarra
For bundled PostgreSQL instances (which you have), the files are by default located in:
C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\x.x
Unbundled or otherwise custom installs can have a different location, as you can choose the data directory.