Skip to content

pg-upgrade-logical: Make sure that the consul service files exist and their names match + Install the latest minor version of PostgreSQL packages

Vitaliy Kukharik requested to merge consul-pre-checks into master

issue: https://gitlab.com/gitlab-com/gl-infra/reliability/-/issues/24338

Make sure that the consul service files exist and their names match with the values of the variables in inventory/group_vars/source_cluster.yml and target_cluster.yml.

New pre-checks:

  • Make sure that the consul service files exist
  • Make sure that the consul service names match

Additionally:

  • Change state ‘present’ to ‘latest’ to install latest version of PostgreSQL packages
    • this ensures that all postgres packages will be installed with the same version

Fixed:

vitaliy@patroni-ci-v14-101-db-gprd.c.gitlab-production.internal:~$ /usr/lib/postgresql/14/bin/pg_dump --version
pg_dump (PostgreSQL) 14.8 (Ubuntu 14.8-1.pgdg20.04+1)
vitaliy@patroni-ci-v14-101-db-gprd.c.gitlab-production.internal:~$ /usr/lib/postgresql/14/bin/psql --version
psql (PostgreSQL) 14.8 (Ubuntu 14.8-1.pgdg20.04+1)
vitaliy@patroni-ci-v14-101-db-gprd.c.gitlab-production.internal:~$ /usr/lib/postgresql/14/bin/postgres --version
postgres (PostgreSQL) 14.9 (Ubuntu 14.9-1.pgdg20.04+1)
Edited by Vitaliy Kukharik

Merge request reports