#POSTGRESQL CONF LOCATION LINUX INSTALL#
#POSTGRESQL CONF LOCATION LINUX PASSWORD#
#POSTGRESQL CONF LOCATION LINUX LICENSE#

You can create a repository QSR, SenseServices, QSMQ, and Licenses database manually with the pgAdmin tool or using a script.

#POSTGRESQL CONF LOCATION LINUX INSTALL#

When you install PostgreSQL EnterpriseDB, the pgAdmin tool is included. Click Finish to complete the installation.Clear the check box if you want to install this later. After running the setup, you have the option to install Stack Builder.In the Ready to Install screen, click Next to run the setup. In the Advanced Options screen, accept the default locale.

This port is required for communication between all the nodes in a site.

#POSTGRESQL CONF LOCATION LINUX PASSWORD#

You will use this password when you connect to the PostgreSQL database and you will also be prompted for it when you run the Qlik Sense setup.

On the Password screen, create a password for the PostgreSQL superuser.

On the Installation Directory and Data Directory screens, accept the default paths.

To know which versions of PostgreSQL are supported in Qlik Sense, see: System requirements for Qlik Sense Enterprise

Log in to the server where you want to install PostgreSQL as an administrator.ĭownload PostgreSQL EnterpriseDB version 12.x from the PostgreSQL website.

To install PostgreSQL on a dedicated server:

Verify that the database has installed and is running correctly.īefore installing a dedicated PostgreSQL server instance, check that your server fulfills the system requirements on Information noteIf you are installing on Microsoft Azure with an Azure database for PostgreSQL, follow the instructions in Installing and configuring PostgreSQL on Azure.

Edit the configuration files to allow access from Qlik Sense nodes.

Create the PostgreSQL databases, and configure login roles.

To install a dedicated PostgreSQL server with QSR, SenseServices, QSMQ, and Licenses database: It is only accessed by the licenses service.

#POSTGRESQL CONF LOCATION LINUX LICENSE#

The licenses database contains a local copy of license data to allow faster response times and more robustness. The NOTIFY and LISTEN functionality in PostgreSQL allows services to be notified about new messages that have been written to the messaging table. The QSMQ database provides a light-weight method of passing messages internally between services in Qlik Sense Enterprise. The Qlik Sense message queue database (QSMQ) The SenseServices database contains schemas for each of the Qlik Sense services and allows growth independently of the Qlik Sense Repository Database, while still sharing the same PostgreSQL instance and login role. The Qlik Sense services database (SenseServices)

If you want to install the QSR database on a dedicated PostgreSQL server, you must install and configure PostgreSQL before you install Qlik Sense, as you will need to enter the PostgreSQL server/host details in the Qlik Sense installer.

The QSR is the primary database in your Qlik Sense deployment. If you use Linux or Amazon RDS, it is your own responsibility to install and configure a running instance of PostgreSQL for Qlik Sense to use. However, Qlik will only offer configuration support when PostgreSQL is running on Windows. You can run the instance of PostgreSQL on platforms including Windows, Linux or cloud hosted services, such as Amazon RDS. To know which versions of PostgreSQL are supported in Qlik Sense, see: System requirements for Qlik Sense Enterprise. Warning noteIf Qlik Sense uses a PostgreSQL database on a dedicated infrastructure, then it can use supported versions of PostgreSQL.

Postgresql conf location linux