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.0.x, introduce the detailed steps:
Obtain the 4.0.x installation package, matrixdb-4.0.x-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 -af
Use root account to upgrade rpm package:
yum upgrade matrixdb-4.0.x-1.el7.x86_64.rpm
Note, do not use
yum erase, otherwise the configuration of the previous version will be deleted.
systemctl restart matrixdb.supervisor.service
Log in to the master host, switch to the mxadmin account, and start the cluster:
su - mxadmin
gpstart -a
If you use the matrixts plugin, connect to the database and upgrade the matrixts plugin using the following SQL commands:
ALTER EXTENSION matrixts UPDATE;