PostgreSQL Version Errors During Installation and Upgrade

This guide describes some PostgreSQL-database-related errors that you may encounter during fresh installation or upgrade.

PostgreSQL Database Server Version Is Not Supported

If postinstall.sh finds that the PrivX database runs on an unsupported PostgreSQL version, it will fail with an error similar to the following:

ERROR: The installation or upgrade process has failed
 because the PostgreSQL database server version is not
 supported. The minimum supported version is PostgreSQL <version>.
 Please upgrade your PostgreSQL server version to <version> or
 higher. After upgrading the database to the required
 version, resume the current operation with:

Resume installation:
    /opt/privx/scripts/postinstall.sh

Resume normal upgrade (not zero-downtime upgrade):
    /opt/privx/scripts/postinstall.sh

Resume first stage upgrade (in zero-downtime upgrade, e.g if version check error occurred while running upgrade_first_stage.sh):
    UPGRADE_STYLE=no_downtime /opt/privx/scripts/postinstall.sh

You will need to upgrade the PrivX database's PostgreSQL server to one of the supported versions. After that, resume installation/upgrade as described in the error message.

If you are upgrading and prompted to continue installation without removing existing files, answer Yes.

Do not perform a clean installation, which would remove important existing files and make PrivX unusable.

Failed to Automatically Determine the PostgreSQL Server Version

If postinstall.sh fails to determine the PrivX database's PostgreSQL version for any reason, it will fail with an error similar to the following:

ERROR: Failed to automatically determine the PostgreSQL
 server version. This PrivX version requires PostgreSQL
 server version <version> or higher. 

If you are certain that your PostgreSQL server is <version> or
 higher, you can explicitly skip the version check. 
Run the following commands to resume the current operation
 while skipping the database version check":

Resume installation:
    export PRIVX_SKIP_DB_VERSION_CHECK=true
    /opt/privx/scripts/postinstall.sh

Resume normal upgrade (not zero-downtime upgrade):
    export PRIVX_SKIP_DB_VERSION_CHECK=true
    /opt/privx/scripts/postinstall.sh

Resume first stage upgrade (in zero-downtime upgrade, e.g if version check error occurred while running upgrade_first_stage.sh):
    export PRIVX_SKIP_DB_VERSION_CHECK=true
    UPGRADE_STYLE=no_downtime /opt/privx/scripts/postinstall.sh

In such cases, verify that the PrivX database is running on a supported PostgreSQL version. Once you are certain the PrivX database is running on a supported PostgreSQL version, you may resume installation/upgrade as described in the error message.

If you are upgrading and prompted to continue installation without removing existing files, answer Yes.

Do not perform a clean installation, which would remove important existing files and make PrivX unusable.

Setting PRIVX_SKIP_DB_VERSION_CHECK=true does not resume installation in situations where postinstall.sh is able to determine an unsupported PostgreSQL version. In such cases, you must update the PostgreSQL server to a supported version to proceed.