Description:
This should have been a HUGE announcement on the ArchLinux front page. But all I can see is deep silence w.r.t. PostgreSQL.

TL;DR: The recent upgrade to PostgreSQL 14.x breaks *everything*, rendering pre-existing PostgreSQL servers inoperable. The only way to restore law and order is to keep 13.x and hope for the best. Forget about pg_upgrade; it just doesn’t work. You will have to restore everything manually, INSERT by INSERT.

How about this? https://githubhot.com/repo/zalando/spilo/issues/602 Hint: Nope, that doesn’t work/help either.

Additional info:
* package version(s)
No precise numbers are needed; this is all about PostgreSQL 13 to 14 upgrades.

* config and/or log files etc.
(1)
could not execute query: ERROR: column reference "backend_type" is ambiguous
(2)
pg_restore: error could not execute query: ERROR: column reference "backend_type" is ambiguous
LINE 34: "get_pg_stat_activity"."backend_type"

* link to upstream bug report, if any

None. This is a distro error. If something doesn’t work, then *please* file an upstream bug, but don’t just let such a disaster pass from “testing” into “extra”, hoping that random users will magically fix it. (They most likely won’t!)

Steps to reproduce:
Upgrade to PostgreSQL 14.x.
Who has a working PostgreSQL 14.x? Anyone…? Thought so. Ideally just don’t upgrade from 13. This is really bad.