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
Xfce4 4.20 upgrade issue on font size
With the recent upgrade of Xfce4 4.20, I was facing the font size issue on my laptop. I am using icewm . And the upgrade causes my fonts become too small. But some applications are too big, like Brave and FreeFileSync. I spent some time to fix this. And this is my final solution,
Allow xfsettingsd at startup,
xfsettingsd --daemon -D
And use xfce4-appearance-settings, at the Fonts > DPI, enable Custom and set the value to 120 as in .Xresources . The effect is immediate. This solves the font size for all applications.