Upgrading postgres version

Suppose you made a brew upgrade and postgres got upgraded. Follow then these steps to upgrade your old DB data to the new version.

Start to move of your old data directory:
mv /usr/local/var/postgres /usr/local/var/postgres_96_20171110

Initialize a new fresh DB with the new version of postgres
initdb /usr/local/var/postgres/

Check which postgres services are running and stop all
brew services list

Stop all postgres services, one command for each:
brew services start postgresql

Run postgres upgrade tool(-b and -B are the bin directories for old and new version, and -d and -D same for data directories):
pg_upgrade -b /usr/local/Cellar/postgresql\@9.6/9.6.6/bin/ -B /usr/local/Cellar/postgresql/10.1/bin/ -d /usr/local/var/postgres_20171110 -D /usr/local/var/postgres

Start the postgres service again:
brew services start postgresql

VoIP on the Qtek9090

Through my work I recently got a Qtek 9090. Since it got WLAN I have been intrested to try VoIP on it but my first attempts at finiding some suitable software turned out eith no results, atleast not any free software. But yesterday evening I looked around a bit more and found atleast two options:

SJPhone has a Free World Diaplup version for PocketPC

WiFive Phone is another option. The WiFive.net homepage is broken at the moment.

So far I have not had time to try them but will try to do it soon. Will update this entry about the results.

ICQ on K700

Jimm – Mobile Messaging is a ICQ client intended to run on mobile phones. Tried it and it works really well. COOL! Only problem is that I would like to minimize the application so I can use the phone as normally.


Sandor frågade om jag visst var den där bredbandstesten som fanns för något år sedan låg. Han har fått sin scream och vill testa. Tänkte det var värt och kolla upp eftersom jag vilken dag som skall få min. Kollade upp IT-kommissionens hemsida först men de hade lagt ned. Dock hittade jag efter lite googlande en länk till IIS och dom har tagit över tjänsten: Bandbreddstestet TPTEST