Showing posts from May, 2020

How to Upgrade PostgreSQL 10 Cluster to 12 in Ubuntu 20.04

W hen I upgraded my Ubuntu 18.04 to 20.04, the PostgreSQL package also got upgraded from version 10 to 12. The upgrade said in order to remove the v10 I have to migrate the clusters first. This is how I migrate the v10 cluster to v12 cluster. To begin with, Postgre has this pg_upgrade command. Here is the link to the documentation. The syntax is as follows: pg_upgrade -b oldbindir -B newbindir -d oldconfigdir -D newconfigdir [ option ...] It is in /usr/lib/postgresql/<version>/bin/ directory . But when I ran this command in my user context, I got Permission Denied. It also forbids running as sudo either. The only way that makes sense now is running this command in postgres user context. Please note that I use the --check flag below to avoid running the real migration. And don't forget to stop the postgresql service before. chris@focal : ~ $ sudo systemctl stop postgresql chris@focal : ~ $ sudo su - postgres postgres@focal : ~ $ /usr/lib/postgresql/12/bin/pg_upgra

Monkey Patching Vagrant LXC Issue in Ubuntu 20.04

Ubuntu 20.04 Focal Fossa was officially launched just a couple of weeks ago. And I thought it was the best time to say goodbye to my Ubuntu 18.04. Looking back then, I was so determined entering the world of Ubuntu 20.04. But little that I knew, I will be losing sleep figuring out why my vagrant lxcs won't "vagrant up".   It started with my attempt to upgrade the operating system. I opened up the Software Updater, but there was no upgrade offer anywhere in the prompt. I checked the settings in Software & Updates app. Looked into the "Updates" tab, the "Notify me of a new Ubuntu version:" option said: "For long term support version". Well, 20.04 is an LTS, isn't it. It should be there, but why it isn't? Changing the option to "For any new version", prompted me with 19.10 upgrade but no thanks, 19.10 is so yesterday.What have I missed? Googled it and I found that Software Updater won't give you the prompt, until the