Small version upgrade refers to upgrading to a new version under the premise that the main version number remains unchanged. For example: upgrade from 4.0.0 to 4.0.2; upgrade from 4.0.0 to 4.1.0
Below, take the example of upgrading from MatrixDB 4.0.0 to 4.2.0, and introduce the detailed steps:
Obtain the 4.2.0 installation package, matrixdb-4.2.0-1.el7.x86_64.rpm from the official website, and copy it to all nodes.
Switch to mxadmin to execute gpstop -af:
su - mxadmin
gpstop -afUse root account to upgrade rpm package:
yum upgrade matrixdb-4.2.0-1.el7.x86_64.rpmNote, do not use
yum erase, otherwise the configuration of the previous version will be deleted.
systemctl restart matrixdb.supervisor.serviceLog in to the master host, switch to the mxadmin account, and start the cluster:
su - mxadmin
gpstart -aIf you use the matrixts plugin and mars plugin, connect to the database and upgrade using the following SQL commands:
ALTER EXTENSION matrixts UPDATE;
ALTER EXTENSION mars UPDATE;