There are some similarities between the Church-Tradition-Scripture and organization-team-code.

Firstly, I need to clarify that, Church teaching doesn’t change, and so Holy Scripture doesn’t change. These are the main differences compared to organization and code.

Now, let me discuss the similarities. Just as the Holy Scripture, the source code doesn’t explain itself. Because the source code is not designed to explain itself. Some of the codes may be plain and easy to read, some may not; they require more background on business logic and the intention of the authors. The main difference is that the Holy Scripture is inspired by the Holy Spirit, which has no errors, while source code may come with mistakes and bugs.

The Boss: AI, give me the file.

AI: Boss, may I know which file?

The Boss: You don’t known which file? You have been with me 5 days already, you still don’t know what I am talking?

AI: Boss, can you describe which file it is, so that I can help?

The Boss: Useless AI, don’t you know you are replaceable? You are fired!!

(Next day)

The Boss: AI, tell me a joke.

If we installed pgvector, upgrading PostgreSQL major version will not success with pg_upgrade. We need to manually dump and restore all databases.
In order to do that,

1. Start the existing version service, eg 16.

2. Run
   pg_dumpall -U postgres -f /path/to/all_dumps.sql

3. Stop service.

4. Upgrade postgresql postgresql-libs postgresql-old-upgrade

5. Re-compile and re-install pgvector.

6. Initialize database, such as
   initdb -D /var/lib/postgres/data --locale=C.UTF-8 --encoding=UTF8

7. Start the newer version service, eg 17.

8. Login as postgres (sudo -u postgres /bin/bash), and run
   psql -f /path/to/all_dumps.sql postgres