Solution for Postgres 11 Upgrade Issues

Solution for Postgres 11 Upgrade Issues


  1. When ServiceDesk Plus is upgrading 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.
  1. 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

                    • 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 ...
                    • SDP MSP solution for postgres 11 upgrade issues

                      When ServiceDesk Plus MSP 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 ...
                    • Upgrade Failure due to the presence of CtrlZ Failure

                      This issue (SD-118352) in fixed in version 14710. Post this release, these characters are handled in the migration itself. If you are planning to migrate from version less than 14610 to 14610, then you can directly migrate to 14710, to handle this ...
                    • Migration failure for Postgres Database with a blank space in it

                      Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...
                    • How to resolve Connectivity issues with Postgresql Database from our product?

                      Log Traces Feb 20, 2024 6:40:00 PM [SYSERR] [INFO] : java.sql.SQLException: java.lang.Exception: Exception during getConnection from pool Exception occurred during get connection from datasource Nov 15, 2023 1:29:10 PM [SYSERR] [INFO] : Caused by: ...