solution for postgres 11 upgrade issues

solution for postgres 11 upgrade issues


  • When Supportcenter Plus is upgraded to 14300 or later, postgres is also upgraded to 11.17. If you are using bundled postgres, data migration through pgdump and restore mechanism also happens.
 
To ensure efficiency in Postgres 11.17, make sure your Windows is updated to the Windows Server 2019 or later. Refer here for more details.
 
  • Missing libraries in Windows machines may lead to upgrade failure. So, make sure your system is installed with important updates from Microsoft, such as Universal C Runtime.
 
  Windows Server that is not up to date may look as follows:
                                                            
      
A fully updated Windows Server will look as follows :
                                                              
 
 

Steps to Install Windows Updates:

             Step 1: Click Start and type "Windows Update" in the search bar.

            Step 2: Under Windows Update Settings, click "Check for updates".

            Step 3: Windows will check for updates and display any available updates.

            Step 4: Click "Install updates" to start the update process.

            Step 5: Windows will download and install the updates. This process may take several minutes or longer, depending on the size and number of updates.

            Step 6: After the updates have been installed, you may be prompted to restart your computer. If so, click "Restart now" to complete the update process.

If you facing the same issue after updating to latest windows updates, you may have missing updates for Universal C Runtime Libraries.

                    New to ADSelfService Plus?

                      • Related Articles

                      • Error - Sanity Failed - Upgrade from 8121 to 11

                        While upgrading from 8121 to 11, after executing Updatemanager.bat and if the update fails, You need to check the Updatemanager logs in the path < Support Center Plus Application path -> Server-> Default-> Logs > .  And if you find the below ...
                      • Steps to revert the environment from an upgrade failure situation ?

                        1. Rename the failed set up installation folder to <supportcenter_old> . Don't delete the installation folder until the process is completed. Download the existing version which you had before this upgrade from the below archives link. ...
                      • 11.0 Upgrade failure Inputs needed for analysis

                        To analyze Supportcenter plus upgrade failure cases (Upgrade from 8121 - to 11.0 version), we need following types of logs. 1) If upgrade itself got failed -> need SCP\server\default\log for analysis 2) After upgrade, if the product does not start, ...
                      • Inline images broken after SCP Upgrade

                        We suspect that this issue may arise if the migration schedule has not been run post-upgrade. To troubleshoot this issue further, we kindly request the output of the following query. Please connect to the database of the working build and execute the ...
                      • Trying to start PostgresSQL server failed - While Upgrading

                        Error Trace. Trying to start PostgresSQL server failed java.net.ConnectException: Trying to start PostgresSQL server failed at com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer.startDBServer(DefaultPostgresDBInitializer.java:177) at ...