Upgrading PostgresDB in an Postgres unbundled Qliksense environment
Hi Community,
We previously unbundled PostgreSQL from our Qlik Sense environment and upgraded to the May 2024 version, as our earlier setup was outdated. Now that May 2024 has reached end of life, we’re planning the next Qlik Sense upgrade. This also means we need to update PostgreSQL again, especially since it contains VA points and relies on older libraries.
I have two main questions:
Can I upgrade PostgreSQL using the Qlik PostgreSQL tool, or do I need to use a separate installer from the PostgreSQL website? I haven’t found clear documentation on this process and would appreciate any advice or best practices.
After upgrading PostgreSQL, what is the correct process to reattach Qlik Sense to the upgraded database without losing any data? Are there specific steps or precautions I should follow to ensure a smooth transition.
Is there any way, I can just re-bundle Qlik Sense with PostgreSQL database? So that in the future we won't have to look at an upgrade as two entities?
Can I upgrade PostgreSQL using the Qlik PostgreSQL tool, or do I need to use a separate installer from the PostgreSQL website? I haven’t found clear documentation on this process and would appreciate any advice or best practices. Yes (only with QPI 2.0 or later). Check the link above.
After upgrading PostgreSQL, what is the correct process to reattach Qlik Sense to the upgraded database without losing any data? Are there specific steps or precautions I should follow to ensure a smooth transition. If it succeeds, there's no need to reattach it.
Is there any way, I can just re-bundle Qlik Sense with PostgreSQL database? So that in the future we won't have to look at an upgrade as two entities? Yes. As this is a complex and delicate step, please make sure you back up the environment before attempting it. In short, you need to back up all 4 postgres databases, uninstall Qlik Sense (keeping files and certificates), uninstall PostgreSQL, reinstall the same version of Qlik Sense you uninstalled earlier (skipping service start), and then restore the PostgreSQL backup.
As I mentioned, this is very delicate and can leave you with a non-functional environment. Make sure you have everything backed up before attempting it.
I hope that helps!
Eduardo Monteiro - Senior Support Engineer @ IPC Global Follow me on my LinkedIn | Know IPC Global at ipc-global.com
Can I upgrade PostgreSQL using the Qlik PostgreSQL tool, or do I need to use a separate installer from the PostgreSQL website? I haven’t found clear documentation on this process and would appreciate any advice or best practices. Yes (only with QPI 2.0 or later). Check the link above.
After upgrading PostgreSQL, what is the correct process to reattach Qlik Sense to the upgraded database without losing any data? Are there specific steps or precautions I should follow to ensure a smooth transition. If it succeeds, there's no need to reattach it.
Is there any way, I can just re-bundle Qlik Sense with PostgreSQL database? So that in the future we won't have to look at an upgrade as two entities? Yes. As this is a complex and delicate step, please make sure you back up the environment before attempting it. In short, you need to back up all 4 postgres databases, uninstall Qlik Sense (keeping files and certificates), uninstall PostgreSQL, reinstall the same version of Qlik Sense you uninstalled earlier (skipping service start), and then restore the PostgreSQL backup.
As I mentioned, this is very delicate and can leave you with a non-functional environment. Make sure you have everything backed up before attempting it.
I hope that helps!
Eduardo Monteiro - Senior Support Engineer @ IPC Global Follow me on my LinkedIn | Know IPC Global at ipc-global.com
