No, even completely reinstalling everything from a fresh vm doesn’t work.
The latest gvm and postgres packages are not compatible with each other
gvm-setup recommends:
] Creating PostgreSQL database
WARNING: database “postgres” has a collation version mismatch
DETAIL: The database was created using collation version 2.40, but the operating system provides version 2.41.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
Not sure where exactly I should execute that ALTER DATABASE postgres REFRESH COLLATION VERSION command.
─$ sudo psql -c “ALTER DATABASE postgres REFRESH COLLATION VERSION”
psql: error: connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed: FATAL: role “root” does not exist