Qlik Community

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
prasanthan_ravindran
Contributor II
Contributor II

Upgrading QlikSense May 2021 doesn't upgrade PostgreSQL version from 9.6 to 12.5.

Hi Team,

Recently I upgraded one of our Qlik Sense server from Feb 2021 to May 2021 version. Upgrade completed successfully. But Though the Qlik Sense got upgraded, PostgreSQL is still the same version (9.6). 

We want PostgreSQL to upgraded to version 12.5. Is there any possibility?

prasanthan_ravindran_0-1624956086664.png

 

Also our system while we are upgrading QlikSense;

1) No Internet Connection

2) Visual C++ 2013 installed (for postgresql 12 it is required C++ 2015 - 2019)

Do you think postgreSQL has not got updated because oft he above following?

Thanks

PR

Labels (1)
  • Other

1 Solution

Accepted Solutions
Bastien_Laugiero

Hello, 

When upgrading to Qlik Sense May 2021, Postgres is not being upgraded along. 

Only when doing a fresh installation of Qlik Sense May 2021, Postgres 12 will be deployed.

There will be an article released this week or next week providing a solution to get Postgres 12 when using the bundled Postgres (The one delivered with the Qlik Sense installer). I will attach the link once available.

Otherwise the alternative is to move to a dedicated Postgres instance in which case you will have control of the Postgres version deployed. 

Hope this helps! 

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.

View solution in original post

8 Replies
Bastien_Laugiero

Hello, 

When upgrading to Qlik Sense May 2021, Postgres is not being upgraded along. 

Only when doing a fresh installation of Qlik Sense May 2021, Postgres 12 will be deployed.

There will be an article released this week or next week providing a solution to get Postgres 12 when using the bundled Postgres (The one delivered with the Qlik Sense installer). I will attach the link once available.

Otherwise the alternative is to move to a dedicated Postgres instance in which case you will have control of the Postgres version deployed. 

Hope this helps! 

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
prasanthan_ravindran
Contributor II
Contributor II
Author

Hi Bastien,
 
If we have C++ with 2013 and working environment with Feb 2021 and planned upgrade this week end.
 
In this case, do we need to upgrade Visual C++ to 2015-2019? with existing postgreSQL 9.6 or this is not mandatory to upgrade into 12.x with May 2021?
 
Thanks
PR
Bastien_Laugiero

Hi! 

Haven't tested this scenario myself, but since VC++ is a Postgres dependency and as the Postgres version will not upgrade I wouldn't expect the need to upgrade it. 

 

Bastien Laugiero
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.
prasanthan_ravindran
Contributor II
Contributor II
Author

Hi Bastien,
 
"There will be an article released this week or next week providing a solution to get Postgres 12 when using the bundled Postgres (The one delivered with the Qlik Sense installer). I will attach the link once available"
 
Kindly let me know is there any update on the above Article?
 
Thanks
Prasanthan
jpjust
Specialist
Specialist

Hi Bastien,

We are in Feb'2021 version of Qliksense and we don't have an plan to upgrade to May version of Qliksense.

We run standalone version of Postgres and the version is 9.6, probably installed with some version of qliksense installation or upgrade.

Do you think for any security concerns, its recommended to upgrade the postgres to 12.5?

Thanks

TusharDev_Qlik
Creator
Creator

Hello @Bastien_Laugiero 

Is there any update on this?

We have upgraded from Nov 2020 to Nov 2021 version and having same query about the postgres database still at 9.6 post upgrade.

TusharDev_Qlik
Creator
Creator

@Maria_Halley 

we followed the same steps mentioned in the article but after reinstalling Central , RIM nodes were in offline status and we have to reinstall them again in order to make the full site operational. This is a test environment but i think for Production we need more efficient solution like maybe upgrading Postgres without affecting current configurations.