article How to change the Qlik Sense Enterprise on Windows PostgreSQL password in Official Support Articles

How to change the Qlik Sense Enterprise on Windows PostgreSQL password

Torsten_Kohrt — Wed, 03 Jul 2024 13:59:43 GMT

During installation, Qlik Sense Enterprise on Windows prompts you to choose a password for its PostgreSQL repository. This password can be changed. The process is split into three steps.

1. Changing the PostgreSQL password in the database

Download and install pgAdmin 4
Connect to your Qlik Sense PostgreSQL database:
1. Host name/address: localhost (if the database has been installed on the local machine)
2. Port: 4432
3. Maintenance database (*): postgres
4. Username: postgres
5. Password: Your current password
  
  (*) Note that the maintenance database name may differ if this was not a standard installation and changes were made during setup. Consult your configuration file if necessary.
Right Click on the postgres database.
Click Query Tool
Copy the following queries into the Query Tool, replacing Example Password with your new password:

ALTER USER postgres WITH PASSWORD 'Example_Password';

ALTER USER qliksenserepository WITH PASSWORD 'Example_Password';
Run the Query

This has changed the password in the database itself. We will now move on to modifying the connection strings used by the database.

2. Changing the Connection String to QSR and QSMQ Database

For this step, we will need the QlikSenseUtil stored in C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\.

It has to be repeated on all nodes.

On the Qlik Sense central node, stop all services except the Qlik Sense Repository Database Service
Open QlikSenseUtil
Open the Connection String Editor and Read the current configuration. This decrypts the current data.
Change the Password in the following two connectionStrings:
- QSR
- QSMQ
Hit Save Value in config file encrypted

We have now changed the connection strings to the QSMQ database and the QSR database.

3. Changing the Connection String for Micro-Services

Qlik Sense has introduced micro-services, all of which will require to have their connection strings modified.

To make changing them easier, we have provided a Configure-Service.ps1 for each. They can be located in:

Always run PowerShell as administrator.

C:\Program Files\Qlik\Sense\Licenses\Configure-Service.ps1
C:\Program Files\Qlik\Sense\NotifierService\install\Configure-Service.ps1
C:\Program Files\Qlik\Sense\AppDistributionService\Configure-Service.ps1
C:\Program Files\Qlik\Sense\HybridDeploymentService\Configure-Service.ps1
C:\Program Files\Qlik\Sense\MobilityRegistrarService\install\Configure-Service.ps1
C:\Program Files\Qlik\Sense\PrecedentsService\install\Configure-Service.ps1
C:\Program Files\Qlik\Sense\NLAppSearch\install\Configure-Service.ps1

Depending on your version of Qlik Sense, the above list may not be complete. Review C:\Program Files\Qlik\Sense\ for any additional micro-service folders that include a Configure-Service.ps1. You can obtain a list of all relevant folders by running the following command in a command prompt: dir /s configure-service.ps1

To update your password using Configure-Service.ps1:

Open an elevated Powershell and change the directory to (for example with the license service) C:\Program Files\Qlik\Sense\Licenses
Run the Configure-Service.ps1 script as follows, providing the correct hostname and the new password:

.\Configure-Service.ps1 YourPostgresHostName 4432 qliksenserepository ExamplePassword

You may receive the following: WARNING: Skipping the database initialization. No superuser or password specified.

This is expected. It does not indicate that the password change has failed.
Repeat these steps for the remaining micro-services. Your PostgreSQL password has now been changed.

If you have not installed Qlik Sense in its default location or have upgraded PostgreSQL, the Configure-Service.ps1 script must be adjusted for each microservice.

Example for changing the install path:

Before:

[string]$senseInstallPath = "$env:ProgramFiles\Qlik\Sense"

After:

[string] $senseInstallPath = "D:\Program Files\Qlik\Sense",

Example for changing the PostgreSQL version:

Before:

[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\9.6"

After:

[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\12.5"

[string]$postgresHome = "$senseInstallPath\Repository\PostgreSQL\14"

Depending on the PostgreSQL version under C:\Program Files\Qlik\Sense\Repository\PostrgreSQL\

Micro-Services Alternative method:

The alternative is to find all the PowerShell files programmatically.

Note that in our example we assume the default install directory and the default port of 4432. You may need to adapt the script accordingly.

# Set the Installation Directory for Qlik Sense
$installDir = 'C:\Program Files\Qlik\Sense\'
# Specify the new password for the qliksenserepository account
$password = 'MyNewPassword'
$files = Get-ChildItem -Path $installDir -Include Configure-Service.ps1 -Recurse
foreach ($file in $files) {
    $ScriptToRun=$($file.FullName)
    &$ScriptToRun localhost 4432 qliksenserepository $password
}

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

tvolkmerwolf — Fri, 30 Jun 2023 12:49:48 GMT

Hi @Torsten_Kohrt ,

at first thanks to you for this information.

In preparation to help a customer with this I started to try the scripts, but already with

C:\Program Files\Qlik\sense\DataPrepService\install\Configure-Service.ps1

I receive an error:

PS C:\Program Files\Qlik\sense\DataPrepService\install> .\Configure-Service.ps1 localhost 4432 qliksenserepository 9ar5on65$ DataPrepService configuration started. WARNUNG: Skiping the database initialization. No superuser or password specified. Creating schema 'dataprep_service'. Invoke-Query : Ausnahme beim Aufrufen von "Start" mit 0 Argument(en): "Das System kann die angegebene Datei nicht finden" In C:\Program Files\Qlik\sense\DataPrepService\install\install-utils\Postgres.ps1:56 Zeichen:12 + $ret = Invoke-Query $command + ~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Invoke-Query], MethodInvocationException + FullyQualifiedErrorId : Win32Exception,Invoke-Query

Sorry, it's partially in German, but it literally says "File not found" when the Invoke-Query command is run.

Environment is QS Enterprise Nov 2022 (Patch 6) on a Windows host.

Can you perhaps give a hint on this?

Many thanks in advance!

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

Torsten_Kohrt — Fri, 30 Jun 2023 17:12:53 GMT

@tvolkmerwolf

Hello Thank you for your message please try a password without $ or @ and try again please. PowerShell cannot handle it the way you are trying.

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

tvolkmerwolf — Mon, 03 Jul 2023 09:34:01 GMT

Hi @Torsten_Kohrt ,

thanks for the answer, but that of course was a fantasie pw, my real PW does not have any special char. Nevertheless I get the error.

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

tvolkmerwolf — Mon, 03 Jul 2023 10:14:11 GMT

Hi @Torsten_Kohrt ,

it's actually line ~104 in the PSQL-Script Postgres.ps1 in the directory

C:\Program Files\Qlik\sense\DataPrepService\install\install-utils

which creates hte process object and then throws $process.Start() . Maybe the blanks in the filename pointing towards the psql.exe gives this behaviour, but so far I've not found on how to correct that.

Maybe this helps? If not, sorry for bothering...

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

tvolkmerwolf — Mon, 03 Jul 2023 10:38:21 GMT

Skip this please, I guess I found it ... forget to adapt the path to the PQSL binary .... Sorry !

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

DimoDataPerformance_Jérôme — Wed, 13 Sep 2023 06:41:50 GMT

Bonjour,

Avec la restriction des caractères avec QPI 1.3.0, la modification a bien fonctionnée pour moi. Quels sont les impacts sur l’utilisation de l’authentification SAML sur ce changement.

1- Changeur du mot de PASSE Postgres

2- Modification de la config via QlikSenseUtil

Dans l’Environnement de DEV, tous est ok, sans ADFS

Environnement PROD, La QMC ne s’ouvre plus. Tous les services démarrent, mais j’ai des erreurs lors du test de la connexion avec QlikSenseUtil

Le problème est-il lié a l'ADFS ou au changement de mot de passe ?

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

Sonja_Bauernfeind — Mon, 18 Sep 2023 11:31:15 GMT

Hello @DimoDataPerformance_Jérôme

Please review Qlik Sense - How to troubleshoot issue to access QMC and HUB on how to troubleshoot QMC access issues. If this does not help you resolve the issue, I recommend logging a support ticket to obtain assistance with your production environment.

Translated:

Veuillez consulter Qlik Sense - How to troubleshoot issue to access QMC and HUB pour savoir comment résoudre les problèmes d'accès à QMC. Si cela ne vous aide pas à résoudre le problème, je vous recommande de créer un ticket d'assistance pour obtenir de l'aide sur votre environnement de production.

All the best,
Sonja

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

tonyiantorno — Tue, 26 Sep 2023 13:19:57 GMT

Hello,

I have completed part 1 and 2 with no issues. However, once I complete the micro-services and reboot the server, my RIM node is offline and I can not redistribute the certificate. Even when uninstalling the RIM and then trying to distribute the certificate I get the pop up window of can't communicate with port 4444.

QS August 2022. This is in preparation to upgrade to PostgreSQL 12.x or 14.x.

Thanks,

Tony

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

aashok — Wed, 27 Sep 2023 05:36:15 GMT

Hi, I am also encountering the issue with the RIM Node.

Also earlier I was following the link on 'how to reset the forgotten password'

https://community.qlik.com/t5/Official-Support-Articles/How-to-reset-forgotten-PostgreSQL-password-i...

and then I came across this page.

I did follow the steps mentioned, but part 3 caused me the error,

like changing the connection string to micro services is not working for all of them,

for eg;

C:\Program Files\Qlik\Sense\NotifierService\install\Configure-Service.ps1

particularly for those ps1 files inside the install folders.

Could help on this matter?

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

khai — Fri, 06 Oct 2023 06:49:43 GMT

I am getting the same error as Tvolkmerwolf and Aashok. I have already changed my powershell working directory to the respective folders, but getting that error for some of the folders.

How do I resolve the errors for:

D:\Program Files\Qlik\Sense\DataPrepService\install
D:\Program Files\Qlik\Sense\NLBroker\install
D:\Program Files\Qlik\Sense\NotifierService\install
D:\Program Files\Qlik\Sense\PrecedentsService\install

PS C:\Program Files\Qlik\sense\DataPrepService\install> .\Configure-Service.ps1 localhost 4432 qliksenserepository Qlikview321xyz
DataPrepService configuration started.
WARNUNG: Skiping the database initialization. No superuser or password specified.
Creating schema 'dataprep_service'..
..

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

Sonja_Bauernfeind — Fri, 06 Oct 2023 07:46:57 GMT

Hello @khai let me look into this for you.

All the best,
Sonja

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

Sonja_Bauernfeind — Fri, 06 Oct 2023 07:52:12 GMT

Hello @khai

The previous two users were engaged in support tickets. One is still under investigation, and one is resolved, though I believe the root causes of both differ.

As for your specific question:

Can you define what error besides the warning you are getting? I've checked with our subject matter experts, and the warning you received is expected for some of the services and should not lead to problems.

In the screenshot below is one warning (the one you received), which can be dismissed, and one error (caused by the script being run after the database had been upgraded using QPI), which is an actual error requiring action.

If you only receive the warning, can you clarify what other symptoms or errors are logged?

All the best,
Sonja

PS: I will be updating the article with this information as soon as possible.

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

khai — Fri, 06 Oct 2023 08:08:22 GMT

Hi @Sonja_Bauernfeind , I am changing the password before the QPI is installed, because the current password contain the restricted special characters. Noted, I have created a support case 00116779 with the error screenshots.

Re: How to change the Qlik Sense Enterprise on Windows PostgreSQL password

ArmaganYali — Wed, 04 Jun 2025 15:24:28 GMT

Hi,

I ran this line .\Configure-Service.ps1 YourPostgresHostName 4432 qliksenserepository ExamplePassword

for postgres as well, that is, as follows .\Configure-Service.ps1 localhost 4432 postgres ExamplePassword.

Everything seems to be working fine, but my SSL certificate on the server started giving a "Not Secure" error. What could be the reason?

Thanks,
Armağan