Converting from Asynchronous to Synchronous Replication in PostgreSQL
High Availability is a requirement for just about every company around the world using PostgreSQL It is well known that PostgreSQL uses Streaming Replication as the replication method. PostgreSQL Streaming Replication is asynchronous by default,...
How to Configure Cluster-to-Cluster Replication for PostgreSQL
As we recently announced, ClusterControl 1.7.4 has a new feature called Cluster-to-Cluster Replication. It allows you to have a replication running between two autonomous clusters. For more detailed information please refer to the above mentioned...
PostgreSQL Backup Method Features in AWS S3
Amazon released S3 in early 2006 and the first tool enabling PostgreSQL backup scripts to upload data in the cloud — s3cmd — was born just shy of a year later. By 2010 (according to...
An Overview of pgModeler for PostgreSQL
When a project is being designed, the first thing to think about is what its purpose will be... what is the best solution, and what are the alternatives. In software engineering, everything is done to...
What's New in PostgreSQL 12
On October 3rd 2019 a new version of the world's most advanced open source database was released. PostgreSQL 12 is now available with notable improvements to query performance (particularly over larger data sets and overall...
An Overview of Various Auxiliary Plan Nodes in PostgreSQL
All modern database system supports a Query Optimizer module to automatically identify the most efficient strategy for executing the SQL queries. The efficient strategy is called “Plan” and it is measured in terms of cost...
Creating a PostgreSQL Replication Setup on Debian / Ubuntu
PostgreSQL can work separately on multiple machines with the same data structure, making the persistence layer of the application more resilient and prepared for some unexpected event that might compromise the continuity of the service....
PostgreSQL Top Learning & Training Resources
Oftentimes, people want to know about “That One Place” to get all their learning and training resources for PostgreSQL. When I get such a question from a colleague, my typical response it to tell them...
The Most Common PostgreSQL Failure Scenarios
There is not a perfect system, hardware, or topology to avoid all the possible issues that could happen in a production environment. Overcoming these challenges requires an effective DRP (Disaster Recovery Plan), configured according to...
Cloud Vendor Deep-Dive: PostgreSQL on Microsoft Azure
If you have followed Microsoft lately it will come as no surprise that the provider of a competing database product, namely SQL Server, also jumped on the PostgreSQL bandwagon. From releasing 60,000 patents to OIN...
An Overview of the JOIN Methods in PostgreSQL
In my previous blog, we discussed various ways to select, or scan, data from a single table. But in practical, fetching data from a single table is not enough. It requires selecting data from multiple...
Cloud Vendor Deep-Dive: PostgreSQL on Google Cloud Platform (GCP)
Where to Start? The best place I could find to start was none other than the official documentation. There is also a GCP Youtube channel for those who prefer multimedia. Once finding myself into the...