An Introduction to TimescaleDB
TimescaleDB is an open-source database invented to make SQL scalable for time-series data. It’s a relatively new database system. TimescaleDB has been introduced to the market two years ago and reached version 1.0 in September...
How to Deploy Highly Available PostgreSQL with Single Endpoint for WordPress
WordPress is an open source software you can use to create your website, blog, or application. There are many designs and features/plugins to add to your WordPress installation. WordPress is a free software, however, there...
Benchmarking Managed PostgreSQL Cloud Solutions: Part Two – Amazon RDS
This is the second part of the multi-series Benchmarking Managed PostgreSQL Cloud Solutions. In Part 1 I presented an overview of the available tools, I discussed the reason for using the AWS Benchmark Procedure for...
Configuring PostgreSQL for Business Continuity
Business Continuity for Databases Business continuity for databases means databases must be continuously operational even during the disasters. It is imperative to ensure that production databases are available for the applications all the time even...
How to Replicate PostgreSQL Data to Remote Sites
In a busy database environment with larger size databases, the need for real-time data replication is a common occurrence. Applications often need the production data to be replicated in real-time to remote sites for analytics...
Benchmarking Managed PostgreSQL Cloud Solutions – Part One: Amazon Aurora
This blog starts a multi-series documenting my journey on benchmarking PostgreSQL in the cloud. The first part includes an overview of benchmarking tools, and kickstarts the fun with Amazon Aurora PostgreSQL. Selecting the PostgreSQL Cloud...
The Current State of Open Source Backup Management for PostgreSQL
There are many ways to address taking backups of a PostgreSQL cluster. There are several articles and blogs which present the various technologies by which we can save our precious data in PostgreSQL. There are...
Migrating from DB2 to PostgreSQL – What You Should Know
Whether migrating a database or an application from DB2 to PostgreSQL with only one type of database knowledge is not sufficient, there are few things to know about the differences between the two database systems....
How to Cluster Odoo 12 with PostgreSQL Streaming Replication for High Availability
Odoo (formerly known as OpenERP) is a suite of open-source business apps. It comes in two versions - community and enterprise. Some of the most popular apps (and free!) integrated within this platform are Discuss,...
Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL
The introduction of DevOps in organizations has changed the development process and also introduced some new challenges. In addition, developers and DevOps teams, along with their own chosen programming languages, also have their favorite database...
An Overview of the Index Changes in PostgreSQL 11
The right application of indexes can make queries blazing fast. Indexes use pointers to access data pages in a speedy fashion. Major changes happened on Indexes in PostgreSQL 11, lots of much awaited patches have...
Automate Deployment of Your MySQL or Postgres Cluster From Backup
ClusterControl 1.7.1 introduces a new feature called Create Cluster from Backup, which allows you to deploy a new MySQL or Postgres-based cluster and restore data on it from a backup. This blog post shows how...