Skip to content

Aus800

IT technologies, especially open source tools

Menu

  • Services
  • About

Database

Postgresql identity column “no owned sequence”

Postgresql 10 introduced identity column which offers better manageability than the old fashioned serial. Refer to this post for more detail I followed the post above and converted most of serial columns into identity, worked all good until one day

Jason July 4, 2020July 4, 2020 Database 1 Comment Read more

PostgreSQL logical replication

Logical replication was introduced in PostgreSQL 10. It offers better flexibility than stream replication in a number of ways: Publisher and subscriber can be on different major versions Replication can be done at table level, sharing a subset of the

Jason May 8, 2020May 8, 2020 Database No Comments Read more

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

Jason December 4, 2018December 4, 2018 Database, virtualisation 2 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

Jason 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

Jason October 26, 2017October 26, 2017 Database No 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

Jason June 15, 2017December 2, 2019 Database 3 Comments Read more

Postgresql upgrade from 9.3 to 9.6

Have been using Postgresql 9.3 for a while until recently after upgrading to PgAdmin4 1.3, I cannot import my backup due to compatibility issue, so I decided to upgrade Postgresql to the current version 9.6. Below are my notes on steps:

Jason March 22, 2017May 21, 2019 Database 1 Comment Read more

Postgresql debugger

It took me a while to figure out how to enable debugger for Postgresql server on Ubuntu. Initially I thought it was pre-packaged by Ubuntu therefore apt-get installed a few packages such as pgadmin3, pgadmin3-dev, postgresql-version.dbg. Here is a post

Jason April 21, 2015December 2, 2019 Database, Programming No Comments Read more

Building a web site using PHP on IIS/SQL server using Windows authentication.

PHP+IIS, although not a popular combination, it may be the easiest solution in a corporate departmental environment, which is largely Windows based. PHP programming won’t be discussed here, rather I’d discuss how Windows authentication is achieved. The beautify of  Windows

Jason September 18, 2014 Database, Programming No Comments Read more

SQL server computed field

I recently came across this very interesting rounding issue in MS SQL server. Originally I thought in order to  keep computation in highest accuracy possible, I should use the max allowed precision, i.e. on SQL server a decimal(38,18). However after definition of

Jason August 28, 2014 Database No Comments Read more

Recent Posts

  • My personal review of Biswap
  • Excited to receive a star from Google :)
  • Scan your bank statements using those free apps
  • Forced my aus800.com.au to https
  • Crypto DeFi Liquidity Pools explained

Recent Comments

  • wangts on Use Cloud function to start and stop Cloud sql
  • wangts on Use Cloud function to start and stop Cloud sql
  • Vemuri Venkateswara Rao on Use Cloud function to start and stop Cloud sql
  • Vemuri Venkateswara Rao on Use Cloud function to start and stop Cloud sql
  • wangts on Use Cloud function to start and stop Cloud sql

Archives

  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • June 2021
  • April 2021
  • 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

  • crypto
  • Database
  • others
  • Programming
  • Reporting
  • Reviews
  • SAP
  • Telco billing
  • Uncategorized
  • virtualisation
Copyright © 2022 Aus800. All rights reserved. Theme Spacious by ThemeGrill. Powered by: WordPress.
 

Loading Comments...