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