topic Re: Changes after upgrading postgres from 12 to 14 in App Development

Changes after upgrading postgres from 12 to 14

Tool_Tip — Mon, 09 Dec 2024 04:42:57 GMT

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_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-postgresql-using-qpi.htm"

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 :

Re: Changes after upgrading postgres from 12 to 14

mpc — Mon, 09 Dec 2024 10:49:05 GMT

Hi,

Quite strange since DB Host Name should be specified after QlikSenseUtil is launched. Di you try to launch it with administrator privilege and check logs as suggested

Best

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Wed, 11 Dec 2024 04:39:19 GMT

Dear Mpc

You have mentioned regarding only point (4) if I am not wrong. If yes can you tell where I can see log file ?

Re: Changes after upgrading postgres from 12 to 14

mpc — Wed, 11 Dec 2024 08:02:06 GMT

Exact,

Point 1,2,3 seem to be correct.
Logs of Qlik Sense utils should be in a folder at the root of the QlikSenseUtil.exe one

Best

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Wed, 11 Dec 2024 08:58:21 GMT

There is nothing in this folder

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Wed, 11 Dec 2024 09:01:50 GMT

Here you go

Error pinging host:'abcd.com:4545' Exception message: No connection could be made because the target machine actively refused it 10.203.17.15:4545

Re: Changes after upgrading postgres from 12 to 14

mpc — Wed, 11 Dec 2024 09:06:23 GMT

And if you retry to launch the tools with administrator privileges

Re: Changes after upgrading postgres from 12 to 14

mpc — Wed, 11 Dec 2024 09:17:34 GMT

Ok, I've a idea, please check this: Postgres database moved to new host but some Qlik ... - Qlik Community - 1714567

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Wed, 11 Dec 2024 10:19:31 GMT

As I mentioned before the default path of postgre has been changed during upgrade;

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

TO : C:\Program Files\PostgreSQL\14

And as per your solution in given URL , we need to connect to qliksenseutil and which again not supposed to be used as per qlik...

Re: Changes after upgrading postgres from 12 to 14

mpc — Wed, 11 Dec 2024 10:22:16 GMT

In the provided solution, no need to connect to QlikSenseUtil, you need to change conf. of microservice, again this check this doc: Postgres database moved to new host but some Qlik ... - Qlik Community - 1714567 only Resolution Part

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Wed, 11 Dec 2024 11:22:09 GMT

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 ?

Re: Changes after upgrading postgres from 12 to 14

mpc — Wed, 11 Dec 2024 11:45:24 GMT

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

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Mon, 23 Dec 2024 04:02:03 GMT

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.

Re: Changes after upgrading postgres from 12 to 14

mpc — Thu, 09 Jan 2025 08:28:53 GMT

Hi,

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

Best

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Thu, 09 Jan 2025 09:35:50 GMT

Dear Mpc

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

Re: Changes after upgrading postgres from 12 to 14

mpc — Thu, 09 Jan 2025 09:42:34 GMT

Hi,

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

You can try to restart your server ?

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Thu, 09 Jan 2025 09:46:55 GMT

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

Re: Changes after upgrading postgres from 12 to 14

mpc — Thu, 09 Jan 2025 09:50:15 GMT

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

Re: Changes after upgrading postgres from 12 to 14

Tool_Tip — Thu, 09 Jan 2025 09:53:49 GMT

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:

Re: Changes after upgrading postgres from 12 to 14

mpc — Thu, 09 Jan 2025 16:30:20 GMT

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\.