PostgreSQL fails while upgrading
PostgreSQL is upgraded to 15.5 from Unravel version 4.7.9.4 onwards. However, if the PostgreSQL fails during the upgrade, do any of the following based on the urgency:
This is the recommended method.
Caution
You can perform a rollback to troubleshoot the PostgreSQL upgrade failure only with Unravel support assistance. The preferred solution is to fix the upgrade issues and roll forward. The rollback should only be done if the upgrade issue cannot be resolved in a timely manner, and Unravel must be brought back online.
When the PostgreSQL upgrade fails, you must fix the upgrade issues, roll forward with the upgrade, and do the following:
Delete the failed progress upgrade directory.
rm /
<Installation directory>/unravel/data/postgres_1.upgUpdate
unravel/data/conf/unravel.effective.yamlto point the PostgreSQL home back to the original version. For example, if you upgrade from 4.7.9.2.3456 to 4.7.9.4.4321 and the PostgreSQL upgrade fails, you must update theunravel.effective.yamlfile as follows:home: pgsql: /opt/unravel/version/4.7.9.4.4321
Should be updated to
home: pgsql: /opt/unravel/version/4.7.9.2.3456
Complete the upgrade with the setup command instead of using the manager utility.
unravel/versions/
{NEW}/setup --config unravel/data/conf/unravel.yaml