pg-upgrade-logical: Make sure that the consul service files exist and their names match + Install the latest minor version of PostgreSQL packages
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