Skip to content

Aus800

IT technologies, especially open source tools

Menu

  • Services
  • About

Uncategorized

Postgresql upgrade from 11.x to 12.1

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) .

wangts November 26, 2019November 27, 2019 Uncategorized No Comments Read more

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

wangts June 8, 2019June 8, 2019 Uncategorized 5 Comments Read more

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

wangts June 7, 2018June 7, 2018 Uncategorized No Comments Read more

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

wangts May 2, 2018May 2, 2018 Uncategorized No Comments Read more

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

wangts May 23, 2017 Uncategorized No Comments Read more

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

wangts May 23, 2017 Uncategorized No Comments Read more

Recent Posts

  • Postgresql identity column “no owned sequence”
  • PostgreSQL logical replication
  • Use Cloud function to start and stop Cloud sql
  • Bigquery parallel loading
  • Dates in SAP

Recent Comments

  • wangts on Use Cloud function to start and stop Cloud sql
  • Travis Spencer on Use Cloud function to start and stop Cloud sql
  • Lexie Gill on Use Cloud function to start and stop Cloud sql
  • wangts on Domain and email hosting
  • Leroy Brock on Domain and email hosting

Archives

  • July 2020
  • May 2020
  • March 2020
  • February 2020
  • December 2019
  • November 2019
  • June 2019
  • February 2019
  • December 2018
  • June 2018
  • May 2018
  • December 2017
  • November 2017
  • October 2017
  • June 2017
  • May 2017
  • March 2017
  • July 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • October 2015
  • September 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • September 2014
  • August 2014
  • May 2014
  • July 2013
  • April 2013
  • March 2013

Categories

  • Database
  • others
  • Programming
  • Reporting
  • Reviews
  • SAP
  • Telco billing
  • Uncategorized
  • virtualisation
Copyright © 2021 Aus800. Powered by WordPress. Theme: Spacious by ThemeGrill.