Clean up PGDG packages on bungei after bookworm upgrade
After setting up a PostgreSQL instance on a new bookworm
machine, backups didn't work:
root@bungei:~# sudo -u torbackup postgres-make-one-base-backup $(grep ^metricsdb-01.torproject.org $(which postgres-make-base-backups ))
Doing metricsdb-01.torproject.org:5432 15/main: bungei.torproject.org-20230531-143231-metricsdb-01.torproject.org-main-15-backup
could not change directory to "/root": Permission denied
pg_basebackup: error: incompatible server version 15.3 (Debian 15.3-0+deb12u1)
pg_basebackup failed with exit code 1
So I upgraded the PostgreSQL-15 client packages using the PDGD Apt repository which provides packages that play nice with the Debian ecosystem:
root@bungei:~# dpkg --list | grep .pgdg
ii libpq5:amd64 15.3-1.pgdg110+1 amd64 PostgreSQL C client library
ii postgresql-client 15+250.pgdg110+1 all front-end programs for PostgreSQL (supported version)
ii postgresql-client-15 15.3-1.pgdg110+1 amd64 front-end programs for PostgreSQL 15
ii postgresql-client-common 250.pgdg110+1 all manager for multiple PostgreSQL client versions
ii python3-psycopg2 2.9.6-1.pgdg110+1 amd64 Python 3 module for PostgreSQL
This ticket is here to ensure that once bungei
is upgraded to bookworm
, those packages are replaced with the Debian archive versions.