topic STT - Upgrading PostgreSQL Repository Troubleshooting in Techspert Talks

topic STT - Upgrading PostgreSQL Repository Troubleshooting in Techspert Talks https://community.qlik.com/t5/Techspert-Talks/STT-Upgrading-PostgreSQL-Repository-Troubleshooting/m-p/2470235#M199 <P>This Techspert Talks session covers:</P> <UL> <LI>Using the Qlik Sense QPI tool</LI> <LI>Upgrading a Stand-Alone Database</LI> <LI>How to resolve common issues</LI> </UL> <P><div class="video-embed-center video-embed"><iframe class="embedly-embed" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FAaqB6Umg2SU%3Ffeature%3Doembed&display_name=YouTube&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DAaqB6Umg2SU&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FAaqB6Umg2SU%2Fhqdefault.jpg&type=text%2Fhtml&schema=youtube" width="600" height="337" scrolling="no" title="STT - Upgrading PostgreSQL Repository Troubleshooting" frameborder="0" allow="autoplay; fullscreen; encrypted-media; picture-in-picture;" allowfullscreen="true"></iframe></div></P> <P> </P> <P><FONT size="6"><SPAN>Chapters: </SPAN></FONT></P> <UL> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=62s" target="_blank">01:02</A></SPAN><SPAN> - Intro to PostgreSQL Repository</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=171s" target="_blank">02:51</A></SPAN><SPAN> – Prerequisites</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=204s" target="_blank">03:24</A></SPAN><SPAN> - What is the QPI tool?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=309s" target="_blank">05:09</A></SPAN><SPAN> - Using the QPI tool</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=567s" target="_blank">09:27</A></SPAN><SPAN> - Removing the old Database Service</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=687s" target="_blank">11:27</A></SPAN><SPAN> - Upgrading a stand-alone to the latest release</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=819s" target="_blank">13:39</A></SPAN><SPAN> - How to roll-back to the previous version</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=886s" target="_blank">14:46</A></SPAN><SPAN> - Troubleshooting upgrading a patched version</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1105s" target="_blank">18:25</A></SPAN><SPAN> - Troubleshooting upgrade security error</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1275s" target="_blank">21:15</A></SPAN><SPAN> - Additional config file settings</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1372s" target="_blank">22:52</A></SPAN><SPAN> - Q&A: Are Initial Releases good to run?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1409s" target="_blank">23:29</A></SPAN><SPAN> - Q&A: When is next release of QPI tool?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1440s" target="_blank">24:00</A></SPAN><SPAN> - Q&A: Which versions have security issues?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1476s" target="_blank">24:36</A></SPAN><SPAN> - Q&A: Is version 16 recommended?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1495s" target="_blank">24:55</A></SPAN><SPAN> - Q&A: What order should upgrades be done in?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1530s" target="_blank">25:30</A></SPAN><SPAN> - Q&A: Will QS May 2022 work with latest PostgreSQL?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1555s" target="_blank">25:55</A></SPAN><SPAN> - Q&A: Are settings saved with an upgrade?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1602s" target="_blank">26:42</A></SPAN><SPAN> - Q&A: Is the upgrade process different if on D drive?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1645s" target="_blank">27:25</A></SPAN><SPAN> - Q&A: Are there any certificate concerns?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1667s" target="_blank">27:47</A></SPAN><SPAN> - Q&A: Can the Repository password be changed?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1688s" target="_blank">28:08</A></SPAN><SPAN> - Q&A: Why the error about running 9.6 after upgrade?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1722s" target="_blank">28:42</A></SPAN><SPAN> - Q&A: How to upgrade QS WITH the bundled repository?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1770s" target="_blank">29:30</A></SPAN><SPAN> - Q&A: Is upgrading PostgreSQL needed with QS 2024?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1818s" target="_blank">30:18</A></SPAN><SPAN> - Q&A: Can we run a Test environment with the same license? </SPAN></LI> </UL> <P> </P> <P><FONT size="6"><SPAN>Resources:</SPAN></FONT></P> <UL> <LI><SPAN><A href="https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238" target="_blank">Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer</A></SPAN></LI> <LI><SPAN><A href="https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-postgresql-using-qpi.htm" target="_blank">Installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer</A></SPAN></LI> <LI><SPAN><A href="https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backing-up-a-site.htm" target="_blank">Backing up a Qlik Sense site</A></SPAN></LI> <LI><SPAN><A href="https://community.qlik.com/t5/Official-Support-Articles/Changing-the-Database-Superuser-Password-without-Qlik-Sense/ta-p/1715064" target="_blank">Changing the Database Superuser Password without Qlik Sense Installed</A></SPAN></LI> <LI><SPAN><A href="https://www.enterprisedb.com/downloads/postgres-postgresql-downloads" target="_blank">PostgreSQL Download site</A></SPAN></LI> </UL> <P><SPAN> </SPAN></P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Community400x200.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/159443i6B1D996B3FBEB917/image-size/medium?v=v2&px=400" role="button" title="Community400x200.png" alt="Community400x200.png" /></span></SPAN></P> <P><SPAN> </SPAN></P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/19162">@Sebastian_Linser</a> </P> Fri, 12 Jul 2024 07:48:43 GMT Troy_Raney 2024-07-12T07:48:43Z STT - Upgrading PostgreSQL Repository Troubleshooting https://community.qlik.com/t5/Techspert-Talks/STT-Upgrading-PostgreSQL-Repository-Troubleshooting/m-p/2470235#M199 <P>This Techspert Talks session covers:</P> <UL> <LI>Using the Qlik Sense QPI tool</LI> <LI>Upgrading a Stand-Alone Database</LI> <LI>How to resolve common issues</LI> </UL> <P><div class="video-embed-center video-embed"><iframe class="embedly-embed" src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FAaqB6Umg2SU%3Ffeature%3Doembed&display_name=YouTube&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DAaqB6Umg2SU&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FAaqB6Umg2SU%2Fhqdefault.jpg&type=text%2Fhtml&schema=youtube" width="600" height="337" scrolling="no" title="STT - Upgrading PostgreSQL Repository Troubleshooting" frameborder="0" allow="autoplay; fullscreen; encrypted-media; picture-in-picture;" allowfullscreen="true"></iframe></div></P> <P> </P> <P><FONT size="6"><SPAN>Chapters: </SPAN></FONT></P> <UL> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=62s" target="_blank">01:02</A></SPAN><SPAN> - Intro to PostgreSQL Repository</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=171s" target="_blank">02:51</A></SPAN><SPAN> – Prerequisites</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=204s" target="_blank">03:24</A></SPAN><SPAN> - What is the QPI tool?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=309s" target="_blank">05:09</A></SPAN><SPAN> - Using the QPI tool</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=567s" target="_blank">09:27</A></SPAN><SPAN> - Removing the old Database Service</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=687s" target="_blank">11:27</A></SPAN><SPAN> - Upgrading a stand-alone to the latest release</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=819s" target="_blank">13:39</A></SPAN><SPAN> - How to roll-back to the previous version</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=886s" target="_blank">14:46</A></SPAN><SPAN> - Troubleshooting upgrading a patched version</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1105s" target="_blank">18:25</A></SPAN><SPAN> - Troubleshooting upgrade security error</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1275s" target="_blank">21:15</A></SPAN><SPAN> - Additional config file settings</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1372s" target="_blank">22:52</A></SPAN><SPAN> - Q&A: Are Initial Releases good to run?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1409s" target="_blank">23:29</A></SPAN><SPAN> - Q&A: When is next release of QPI tool?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1440s" target="_blank">24:00</A></SPAN><SPAN> - Q&A: Which versions have security issues?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1476s" target="_blank">24:36</A></SPAN><SPAN> - Q&A: Is version 16 recommended?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1495s" target="_blank">24:55</A></SPAN><SPAN> - Q&A: What order should upgrades be done in?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1530s" target="_blank">25:30</A></SPAN><SPAN> - Q&A: Will QS May 2022 work with latest PostgreSQL?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1555s" target="_blank">25:55</A></SPAN><SPAN> - Q&A: Are settings saved with an upgrade?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1602s" target="_blank">26:42</A></SPAN><SPAN> - Q&A: Is the upgrade process different if on D drive?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1645s" target="_blank">27:25</A></SPAN><SPAN> - Q&A: Are there any certificate concerns?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1667s" target="_blank">27:47</A></SPAN><SPAN> - Q&A: Can the Repository password be changed?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1688s" target="_blank">28:08</A></SPAN><SPAN> - Q&A: Why the error about running 9.6 after upgrade?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1722s" target="_blank">28:42</A></SPAN><SPAN> - Q&A: How to upgrade QS WITH the bundled repository?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1770s" target="_blank">29:30</A></SPAN><SPAN> - Q&A: Is upgrading PostgreSQL needed with QS 2024?</SPAN></LI> <LI><SPAN><A href="https://www.youtube.com/watch?v=AaqB6Umg2SU&t=1818s" target="_blank">30:18</A></SPAN><SPAN> - Q&A: Can we run a Test environment with the same license? </SPAN></LI> </UL> <P> </P> <P><FONT size="6"><SPAN>Resources:</SPAN></FONT></P> <UL> <LI><SPAN><A href="https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238" target="_blank">Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer</A></SPAN></LI> <LI><SPAN><A href="https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-postgresql-using-qpi.htm" target="_blank">Installing or upgrading PostgreSQL using the Qlik PostgreSQL Installer</A></SPAN></LI> <LI><SPAN><A href="https://help.qlik.com/en-US/sense-admin/May2024/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backing-up-a-site.htm" target="_blank">Backing up a Qlik Sense site</A></SPAN></LI> <LI><SPAN><A href="https://community.qlik.com/t5/Official-Support-Articles/Changing-the-Database-Superuser-Password-without-Qlik-Sense/ta-p/1715064" target="_blank">Changing the Database Superuser Password without Qlik Sense Installed</A></SPAN></LI> <LI><SPAN><A href="https://www.enterprisedb.com/downloads/postgres-postgresql-downloads" target="_blank">PostgreSQL Download site</A></SPAN></LI> </UL> <P><SPAN> </SPAN></P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Community400x200.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/159443i6B1D996B3FBEB917/image-size/medium?v=v2&px=400" role="button" title="Community400x200.png" alt="Community400x200.png" /></span></SPAN></P> <P><SPAN> </SPAN></P> <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/19162">@Sebastian_Linser</a> </P> Fri, 12 Jul 2024 07:48:43 GMT https://community.qlik.com/t5/Techspert-Talks/STT-Upgrading-PostgreSQL-Repository-Troubleshooting/m-p/2470235#M199 Troy_Raney 2024-07-12T07:48:43Z Re: STT - Upgrading PostgreSQL Repository Troubleshooting https://community.qlik.com/t5/Techspert-Talks/STT-Upgrading-PostgreSQL-Repository-Troubleshooting/m-p/2499134#M213 <P>Thanks for sharing</P> Mon, 23 Dec 2024 10:49:23 GMT https://community.qlik.com/t5/Techspert-Talks/STT-Upgrading-PostgreSQL-Repository-Troubleshooting/m-p/2499134#M213 F_B 2024-12-23T10:49:23Z