This topic describes how to upgrade VMware Postgres from a previous major version to v14.2.0.
VMware Postgres 14.2 supports the ability to upgrade from any prior VMware Postgres major version to 14.2.0. The steps rely on the open source Postgres
Note: Customers on VMware Postgres 10.x, 11.x, or 12.x who use the PostGIS extension cannot upgrade to 14.2, as the PostGIS versions are incompatible.
pg_upgrade. The default
pg_upgradesetting copies all data files from the old to the new server. Alternatively, review the
--linkoption, that provides reduced upgrade time and disk space benefits but impacts the revert process. For more details see Reverting an old cluster. For a list of all the
pg_upgradeoptions see Options in the pg_upgrade Open Source Postgres documentation.
Start from step 3 in the Usage topic of the pg_upgrade Open Source Postgres documentation.
Replace the commands in step 3, Install the new PostgreSQL binaries, with the following command that installs the new VMware Postgres binaries:
cd ~/Downloads sudo yum install vmware-postgres-14.2-0.el7.x86_64.rpm
Follow the remaining steps as outlined in pg_upgrade.
If you are upgrading a minor VMware Postgres installation (for example 14.0) to a later VMware Postgres minor release, use the
yum update command to install the new RPM:
cd ~/Downloads sudo yum update vmware-postgres<version>-<postgres-version>.el7.x86_64.rpm
Restart the Postgres server:
su postgres pg_ctl restart
Note that the Postgres JDBC driver is not installed as an RPM. Simply extract and use the newer JAR file in your