Skip to main content
Version: v38

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.

caution

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.

caution

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.

info

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.

Page updated on