Changes after upgrading postgres from 12 to 14

[Tool_Tip]

Dear all,

After upgrading postgres from 12 to 14, we have found  below new changes to our enviornment, which we want to understand/confirm if those are normal:

Steps followed using URL "https://help.qlik.com/en-US/sense-admin/November2024/Subsystems/DeployAdministerQSE/Content/Sense_De... 

1) Qlik Sense Repository Database service is disappeared 

2) New service named postgresql-x64-14  is running

3) Default path of postgres changed 

    FROM : C:\Program Files\Qlik\Sense\Repository\PostgreSQL\12.5

    TO : C:\Program Files\PostgreSQL\14

4) Unable to run Qliksenseutil as it is throwing below error :

[Tool_Tip]

Okay. So is it mandatory to provide new passport in highlighted script below or we can provide same existing password and also we need to change the postrgres path to our new folder path that is 

C:\Program Files\PostgreSQL\14

correct ?

[mpc]

You will need to change the path to C:\Program Files\PostgreSQL\14 and use your current password 🙂 

[Tool_Tip]

Dear Mpc,

Can you check if below code is correct as per our discussion :

We have changes in two places:

1) We have kept $newdatabasehostname='localhost' as local host as we have just changed the path for postgres on existing server.

2) postgresHome 'C:\Program Files\PostgreSQL\14' : as per our discussion we have changed the path to newly installed postgres home location

Steps:

1) Stop all the qliksense service except "postgresql-x64-14 - PostgreSQL Server 14".

2) Run above script 

Please let me know if anything else needs to change.

[mpc]

Hi, 

If $password is set correctly, everything should run fine, launched with Admin privilege 

Best

[Tool_Tip]

Dear Mpc

I have executed poweshell script, But I am sure it is success as I can see some warning messages:

[mpc]

Hi, 

I think it's ok, this warning can be ignored. 

You can try to restart your server ? 

[Tool_Tip]

No. I did not restarted but I check one of the Configure-Service.ps1 for 
C:\Program Files\Qlik\Sense\AppDistributionService

And It is still showing older path

[mpc]

Ok, then you'll need to update each file manually unfortunately 

[Tool_Tip]

Thank you. I will then do all the files manually.
Just for information to know what if I did not update these Configure-Service.ps1 files?
And from the below list which are all folder contains this file to update:

[mpc]

I've no clue why this happened, but I've encountered the case several times. 
Files are listed in Configure-Service.ps1 in C:\program files\Qlik\Sense\.