Offline Upgrade - Postgresql Module¶

This page explains how to install or upgrade the middleware - Postgresql module after downloading it from the Download Center.

Info

The term mcamel used in the following commands or scripts is the internal development code name for the middleware module.

Load Images from Installation Package¶

You can load the images using either of the two methods described below. It is recommended to choose the chart-syncer method if there is an image repository available in your environment, as it is more efficient and convenient.

Sync Images to Image Repository using chart-syncer¶

Create load-image.yaml .

Note

All parameters in this YAML file are mandatory. You need to have a private image repository and modify the relevant configuration.

Installed chart repoUninstalled chart repo

If you have an installed chart repo in the current environment, chart-syncer also supports exporting charts as tgz files.

load-image.yaml

source:
  intermediateBundlesPath: mcamel-offline # the relative path to where you execute the __charts-syncer__ command, not the relative path between this YAML file and the offline package
target:
  containerRegistry: 10.16.10.111 # replace with your image repository url
  containerRepository: release.daocloud.io/mcamel # replace with your image repository
  repo:
    kind: HARBOR # or any other supported Helm Chart repository type
    url: http://10.16.10.111/chartrepo/release.daocloud.io # replace with chart repo url
    auth:
      username: "admin" # your image repository username
      password: "Harbor12345" # your image repository password
  containers:
    auth:
      username: "admin" # your image repository username
      password: "Harbor12345" # your image repository password

If you don't have an installed chart repo in the current environment, chart-syncer also supports exporting charts as tgz files and storing them in the specified path.

load-image.yaml

source:
  intermediateBundlesPath: mcamel-offline # the relative path to where you execute the __charts-syncer__ command, not the relative path between this YAML file and the offline package
target:
  containerRegistry: 10.16.10.111 # replace with your image repository url
  containerRepository: release.daocloud.io/mcamel # replace with your image repository
  repo:
    kind: LOCAL
    path: ./local-repo # local path to the chart
  containers:
    auth:
      username: "admin" # your image repository username
      password: "Harbor12345" # your image repository password

Run the command to sync the images.

charts-syncer sync --config load-image.yaml

Load Directly from Docker or containerd¶

Extract and load the image files.

Extract the tar archive.

tar -xvf mcamel-postgresql_0.5.1_amd64.tar
cd mcamel-postgresql_0.5.1_amd64
tar -xvf mcamel-postgresql_0.5.1.bundle.tar

After successful extraction, you will have three files:

hints.yaml
images.tar
original-chart

Load the images to Docker or containerd from the local directory.
Dockercontainerd
docker load -i images.tar
ctr -n k8s.io image import images.tar

Note

Docker or containerd image loading operations need to be performed on each node. After loading is complete, tag the images to maintain consistency with the Registry and Repository used during installation.

Upgrade¶

There are two ways to upgrade. You can choose the corresponding upgrade method based on the prerequisite operations:

Upgrade via helm repoUpgrade via chart package

Check if the helm repository exists.
```
helm repo list | grep postgresql
```
If the result is empty or shows the following prompt, proceed to the next step; otherwise, skip the next step.
```
Error: no repositories to show
```

Add the helm repository.

helm repo add mcamel-postgresql http://{harbor url}/chartrepo/{project}

Update the helm repository.

helm repo update mcamel/mcamel-postgresql # This may fail if the helm version is too low. In that case, try executing __helm update repo__ instead.

Select the version you want to install (we recommend installing the latest version).

helm search repo mcamel/mcamel-postgresql --versions

[root@master ~]# helm search repo mcamel/mcamel-postgresql --versions
NAME                            CHART VERSION   APP VERSION     DESCRIPTION               
mcamel/mcamel-postgresql     0.5.1           0.5.1           A Helm chart for Kubernetes
...

Back up the --set parameters.

Before upgrading the version, it is recommended to execute the following command to back up the --set parameters of the old version.
```
helm get values mcamel-postgresql -n mcamel-system -o yaml > mcamel-postgresql.yaml
```

Run helm upgrade .

Before upgrading, it is recommended to replace the global.imageRegistry field in mcamel-postgresql.yaml with the address of the image repository you are currently using.

export imageRegistry={your image repository}

helm upgrade mcamel-postgresql mcamel/mcamel-postgresql \
  -n mcamel-system \
  -f ./mcamel-postgresql.yaml \
  --set global.imageRegistry=$imageRegistry \
  --version 0.5.1

Back up the --set parameters.

Before upgrading the version, it is recommended to execute the following command to back up the --set parameters of the old version.
```
helm get values mcamel-postgresql -n mcamel-system -o yaml > mcamel-postgresql.yaml
```