OMG: Postgres upgrade on whitby

There'll be downtime of services using Postgres starting ... in a few minutes.

This means:

• keycloak
• panettone (hi)
• paroxysm (the cursed IRC bot)

I think that's it.

We're targeting an upgrade to Postgres 16. We're currently on 11, and I think we have to go through the update steps one by one.

Upgrade docs: https://www.postgresql.org/docs/12/pgupgrade.html

1. tazjin updated the body of this issue at 2023-11-05T08·48+00

2. ​cl/9945: upgrade to PostgreSQL 12 ​cl/9946: upgrade to PostgreSQL 13 ​cl/9947: upgrade to PostgreSQL 14 ​cl/9948: upgrade to PostgreSQL 15 ​cl/9949: upgrade to PostgreSQL 16

   tazjin at 2023-11-05T08·53+00

3. Upgrade from 11 -> 12 completed.

   11 -> 12
   11: /nix/store/ipgbh95kih220m3kyj3ra63y72qms2qb-postgresql-11.21/bin
   12: /nix/store/04ypkmfi12g6sfsik4nkbwd04wzvrpjp-postgresql-12.16/bin
   
   # in /var/lib/postgresql
   sudo -u postgres /nix/store/04ypkmfi12g6sfsik4nkbwd04wzvrpjp-postgresql-12.16/bin/initdb -D /var/lib/postgresql/12
   
   sudo -u postgres /nix/store/04ypkmfi12g6sfsik4nkbwd04wzvrpjp-postgresql-12.16/bin/pg_upgrade --old-bindir /nix/store/ipgbh95kih220m3kyj3ra63y72qms2qb-postgresql-11.21/bin --new-bindir /nix/store/04ypkmfi12g6sfsik4nkbwd04wzvrpjp-postgresql-12.16/bin --old-datadir /var/lib/postgresql/11.1/ --new-datadir /var/lib/postgresql/12/ --check
   

   tazjin at 2023-11-05T09·04+00

4. Turns out we could go from 12 directly to 16, so I skipped the intermediate steps. We're on 16 now.

   tazjin at 2023-11-05T09·12+00

5. cl/9949 is submitted, upgrade to 16 is completed. That should buy us a few years!))

   tazjin at 2023-11-05T09·16+00

6. tazjin closed this issue at 2023-11-05T09·16+00