This is a new post based on my previous “Postgresql upgrade from 9.6 to 10.0“, with necessary updates and corrections. The latest Postgresql 12 (12.1) further improved performance on parallel queries, partitions, automatic (but overridable) inlining of common table expressions (CTEs) .
Domain and email hosting
I recently moved my email service to Zoho as the free email service offered by my hosting company (Inmotionhosting) had never been great: delays, failures of sending and sometimes even email loss. OK, it’s a free service so nothing to
Building a development box on Docker
This article is going to show steps and configurations on how to build a development box (PHP CodeIgniter + Apache + PostgreSQL) using Docker on Windows. Why Docker Comparing to VirtualBox, itās a lot easier and probably faster Portable. Files
Upgrading PostgreSQL from 10.1 to 10.3
After upgrading PgAdmin4 V2 to V3, I start receiving this annoying message pg_restore: [archiver] unsupported version (1.13) in file header Therefore started the migration process, which is a lot easier than I thought š Below assumes you’re already on
Using Oracle SQL Developer Data Modeller (SDDM) for Postgresql
I have been searching for a good data modelling tool (ER modelling) for PostgresqlĀ – have tried a number of products but none of them are satisfactory except for SAP Powerdesigner which I really like. However it’s expensive and I don’t
Postgresql 10 new features
Personally excited about the new version of Postgresql V10. It’s still in beta stage but it has following exciting new features that I have been waiting for: Table partition. A genuine identify column. The previousĀ serial is implemented by a separate