My Favorite PostgreSQL Extensions – Part Two
This is the second part of my blog “My Favorite PostgreSQL Extensions” wherein I had introduced you to two PostgreSQL extensions, postgres_fdw and pg_partman. In this part I will explore three more. pgAudit The next...
Tips for Managing PostgreSQL Remotely
A wide range of resources are available for you when managing your PostgreSQL database clusters remotely. With the right tools managing it remotely is not a difficult task. Using fully-managed services for PostgreSQL offers an...
My Favorite PostgreSQL Extensions – Part One
This is in continuation of my previous blog entry wherein I had touched upon a topic of PostgreSQL Extensions. PostgreSQL Extensions are a plug and play set of enhancements that add an extra feature-set to...
PostgreSQL Load Balancing in the Cloud Made Easy
We’d mentioned many times the advantages of using a Load Balancer in your database topology. It could be for redirecting traffic to healthy database nodes, distribute the traffic across multiple servers to improve performance, or...
PostgreSQL Version Control with Atlassian Bitbucket
In systems engineering, communication is a key element to achieving success on any project. This is because it’s critical to the entire cycle of development; starting from collecting requirements to delivering a minimum viable product....
Implementing a Multi-Datacenter Setup for PostgreSQL – Part Two
This blog is the second part of Implementing a Multi-Datacenter Setup for PostgreSQL. In this blow, we will show how to deploy PostgreSQL in this type of environment and how to failover in the case...
PostgreSQL Backups: What is pg_dumpall?
PostgreSQL is an open-source database management system that can be used to store or interact with the data of any application or website. If you are using a PostgreSQL database to store the information of...
Implementing a Multi-Datacenter Setup for PostgreSQL – Part One
Having a multi-datacenter setup is a common topology for a Disaster Recovery Plan(DRP), but there are some limitations around implementing this kind of environment. You should first solve the communication between the data centers by...
Multi-DC PostgreSQL: Setting Up a Standby Node at a Different Geo-Location Over a VPN
Previously, we wrote about Setting Up a Geo-Distributed Database Cluster Using MySQL Replication. This time, it's about PostgreSQL. Setting up a geo-distributed cluster for PostgreSQL is not a new concept and the topology is quite...
Database Backups 101: What is Point in Time Recovery?
Point-in-Time Recovery (PITR) allows a database administrator to restore or recover a set of data from a backup from a particular time in the past, using a tool or a system. Once PITR starts logging...
An Overview of Generated Columns for PostgreSQL
PostgreSQL 12 comes with a great new feature, Generated Columns. The functionality isn’t exactly anything new, but the standardization, ease of use, accessibility, and performance has been improved in this new version. A Generated Column...
How to Enable TimescaleDB on an Existing PostgreSQL Database
Curious how ClusterControl can help you design and implement environment agnostic deployment patterns? Join our final webinar of 2025! If you have a PostgreSQL cluster up-and-running, and you need to handle data that changes with...