Organization, team, and code
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 and the AI
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.
PostgreSQL major upgrade with pgvector
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,
-
Start the existing version service, eg 16.
-
Run
pg_dumpall -U postgres -f /path/to/all_dumps.sql -
Stop service.
-
Upgrade
postgresql postgresql-libs postgresql-old-upgrade -
Re-compile and re-install
pgvector. -
Initialize database, such as
initdb -D /var/lib/postgres/data --locale=C.UTF-8 --encoding=UTF8 -
Start the newer version service, eg 17.
-
Login as
postgres(sudo -u postgres /bin/bash), and run
psql -f /path/to/all_dumps.sql postgres