[Server] - Upgrading Postgres to 12.22

Overview

This guide provides step-by-step instructions to upgrade the PostgreSQL image version within your CircleCI Server configuration, specifically in the values.yaml file.

Prerequisites

• Access to your CircleCI Server instance.
• Knowledge of how to edit values.yaml.

Step 1: Update the values.yaml File

1. Access Your CircleCI Server: Use your preferred method (SSH or direct file access) to log into your CircleCI Server.
2. Open the values.yaml file.
3. Locate the PostgreSQL image configuration: Look for the section that defines the PostgreSQL image. It should look like the following:

postgresql:
  auth:
   postgresPassword: ""

1. Update the tag to the new PostgreSQL version:

postgresql:
  auth:
    postgresPassword: ""
  image:
    tag: 12.22.336-09d0915

Please note that CircleCI only supports upgrading to the 12.22 image as defined above.

Step 3: Apply the Changes

After updating your values.yaml file, you'll need to apply these changes to the CircleCI Server:

$ namespace=<namespace>
$ USERNAME=<USERNAME>
$ PASSWORD=<PASSWORD>
$ helm upgrade circleci-server oci://cciserver.azurecr.io/circleci-server -n $NAMESPACE --version <version> -f <path-to-values.yaml> --username $USERNAME --password $PASSWORD

For more information on how to upgrade, please see here.

Step 4: Verify the Upgrade

1. Check the logs: After applying your changes, monitor the CircleCI Server logs to ensure that PostgreSQL has started correctly with the new version.