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

I am using Arch Linux, and recently there are some issues on MySQL Workbench and pgAdmin 4.

MySQL Workbench with the latest version 8.0.12 has issue to make connection through the SSH tunnelling. As a result, I have to downgrade to version 6.3.10. However, with the recent upgrade of icu package to 62.1, it breaks the MySQL Workbench 6.3.10. In order to solve this, I duplicate the following files,

[code lang=text] cp libicudata.so.62 libicudata.so.61 cp libicui18n.so.62 libicui18n.so.61 cp libicuuc.so.62 libicuuc.so.61 [/code]

The latest Firefox version 57 and above, a.k.a Firefox Quantum, it is fast, but… that is not what I need.

As a developer, I favoured Chromium more than Firefox. And I use Firefox mainly for downloading. The addon DownThemAll is the must. The greatest feature I love is the ability to highlight and download the selected hyperlinks as batch. And I can name the downloaded files by original filename or based on the text in HTML.

I was switching from Chromium to Firefox as my primary web browser recently. Then, I switched back to Chromium again.

Chrome was usually claimed that it consumes a lot of memory. And recent Firefox updates claim that it is faster and consumes less memory. That is why, I switched to Firefox. I agree that, it is much faster than before. However…

I faced a critical issue. One less important issue that I would like to mention is, Firefox does not support Google Hangout.

My first open source project, Prayer Clock, I moved from SourceForge to GitHub recently. Yeah! Everyone should git!!!

And today I just made some changes, and updated to GTK3.

[gallery ids=“1757,1758” type=“rectangular”]

With GTK 3, I removed the title bar. But not yet successfully moving the menu bar to the icon like Evince or Nautilus.

I plan to convert the right hand panel to WebKitGtk. But this will not be the priority yet.

Yes, again web browser. I am using Firefox. Only sometimes Chromium (Google Chrome). Mainly Firefox. If someone ask me, which one I choose, I definitely answer Firefox. But, if someone ask me, which one I prefer, then it will be difficult to answer.

Firstly, I would like to go through why I choose Firefox as my primary web browser.

Because of DownThemAll. There is no alternative extension in Google Chrome like DownThemAll. Why I like DownThemAll so much? I use DownThemAll with GreaseMonkey to download my favourite mangas (comics). This is something Google Chrome still cannot do it, based on my current knowledge. GreaseMonkey generates the links, right-click, then I DownThemAll.

I am always looking for a good solution (not a software, but a solution) to manage all my contacts and calendar. Actually I separate both of them, even they are under PIM (personal information management).

I was using an excel file to manage all my contacts. But we know, a file is different from an application, the interface is not usable, and I had the difficulty to find the contacts that I want.

Once I was looking for “expression calculator”. The expression calculator is different from normal calculator like calc.exe, which cannot use variable freely as algebra. But the expression calculator, we can predefine a variable with a value, then evaluate the variables in algebraic expression. It is very useful. My favourite expression calculator is SpeedCrunch.

Then, recently, I want to test a math function in SpeedCrunch, but this is impossible, since expression calculator can only define the variable, but not define a function. I remembered the title of Python Tutorial, “Using Python as a Calculator”. Yes, expression calculator, with ability to define function, then Python will be the one.

Compare to the Firefox, I prefer to run Chromium in my netbook. This is because the screen of the netbook is small, and the resolution is low. Using Firefox, the toolbars and file menu already occupies half of the screen. I think Firefox 4.0 will solve my problem.

Then, using Firefox on the netbook with Ubuntu, playing Castle Age will make Firefox slow down. May be the reason is the netbook memory is smaller than normal laptop.

When I was using Windows to manage my files, I always open a lot of windows to move my files. Even the window is already open, I will open a new window.  Because it is difficult for me to find the opened windows. And my taskbar will full of tasks.

So, I tried to find a Windows Explorer replacement. Tried all the best free file managers by Gizmo’s Freeware. Then, only FreeCommander fulfils my needs. There is no need to open a lot of windows.