Skip to content

Aus800

IT technologies, especially open source tools

Menu

  • Services
  • About

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

wangts May 4, 2018May 4, 2018 others 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

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

wangts December 29, 2017December 29, 2017 Programming No Comments Read more

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

wangts November 1, 2017November 23, 2017 Database No Comments Read more

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

wangts October 26, 2017October 26, 2017 Database No Comments Read more

Blurry text on big monitor (full HD)

I recently bought a 2nd monitor (Samsung S24F350FHE 23.6” Full HD) and connected it to my laptop; It however annoyed me that everything I dragged to this big screen appeared ugly – fonts looked blurry comparing to what’s on my built-in

wangts June 28, 2017December 31, 2019 others, Reviews 3 Comments Read more

Enable debug in PostgreSQL

PgAdmin comes with built-in support for debugging your Pl/PgSQL programs. However in order to enable this, you’ll have to compile and install extra plug-in to PostgreSQL. I Googled a lot but didn’t find one single post with all steps so

wangts June 15, 2017December 2, 2019 Database 3 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

Configure Google Cloud Platform – Creating a virtual machine

In this article, I’m going to demonstrate how to configure a Virtual Machine(VM) on Google Cloud Platform. Create a VM Go to Home->Compute Engine, and “CREATE INSTANCE”             Once an instance is created, it will

wangts May 16, 2017May 16, 2017 others, Reviews No Comments Read more
  • « Previous
  • Next »

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.