The crunchy-upgrade container contains both the 9.5 / 9.6 and 9.6 / 10 PostgreSQL packages in order to perform a pg_upgrade from 9.5 to 9.6 or 9.6 to 10 versions.
The following features are supported by the crunchy-upgrade container:
- Supports a pg_upgrade of the PostgreSQL database.
- Doesn’t alter the old database files.
- Creates the new database directory.
- Does not currently support a PostGIS upgrade.
- Supports upgrades from only 9.5 to 9.6, or 9.6 to 10.
The crunchy-upgrade Docker image contains the following packages (versions vary depending on PostgreSQL version):
- PostgreSQL (11.1, 10.6, 9.6.11 and 9.5.15)
- CentOS7 - publicly available
- RHEL7 - customers only
|OLD_DATABASE_NAME||None||Refers to the database (pod) name that we want to convert.|
|NEW_DATABASE_NAME||None||Refers to the database (pod) name that is given to the upgraded database.|
|OLD_VERSION||None||The PostgreSQL version of the old database.|
|NEW_VERSION||None||The PostgreSQL version of the new database.|
|PG_LOCALE||Default locale||If set, the locale you want to create the database with.|
|XLOGDIR||None||If set, initdb will use the specified directory for WAL.|
|CRUNCHY_DEBUG||FALSE||Set this to true to enable debugging in logs. Note: this mode can reveal secrets in logs.|
Data checksums on the Crunchy PostgreSQL container were enabled by default in version 2.1.0.
When trying to upgrade, it’s required that both the old database and the new database
have the same data checksums setting. Prior to upgrade, check if
were enabled on the database by running the following SQL: