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
Data recovery tool
I was really amazed by a data recovery tool I recently used – it recovered files used to be on Windows from a Linux formatted disk! A really great tool I highly recommend! The tool R-Studio has Windows, Linux and
Building a PostgreSQL docker container with debugger (pldebugger)
Further to my previous post, I wanted to enable debugging in PostgreSQL Docker container so that it can be used together with PGAdmin4. The challenge is it is not enabled by default in any of available Docker images; I also
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
Using Putty to connect to Google Cloud VM (Compute Engine)
You can always use the SSH link on the cloud page to connect to your VM, however that user name is what’s your Google account name. Below I’m showing how to use Putty to connect to the same instance with
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
Running a Django application on IIS
Django is a popular Python web framework, below is how to use IIS(Internet Information Service) to host Django application on Windows. Install Python on Windows https://python.org Create a python virtual environment so your future development won’t rely on existing Python executables
Deploy pgAdmin as a web service under venv environment
pgAdmin can be deployed as a web server therefore user doesn’t need to install any client to access DB. This also provides a securer way of accessing your database: suppose your web server is on the same network as your
Postgresql upgrade from 9.6 to 10.0
The lasted Postgresql 10 brings in a number of exciting new features: parallel queries, partitions, new sequence and logical replication. Below are steps to upgrade v9.6 to v10. It has similar steps as described in my previous post “Postgresql upgrade