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
If you have a PostgreSQL cluster up-and-running, and you need to handle data that changes with time (like metrics collected from a system) you should consider using a time-series database that is designed to store...
How to Rebuild an Inconsistent PostgreSQL Slave
PostgreSQL Streaming Replication is a great way of scaling PostgreSQL clusters and doing it adds high availability to them. As with every replication, the idea is that the slave is a copy of the master...
What to Look for if Your PostgreSQL Replication is Lagging
PostgreSQL is designed to handle multiple threads, such as query parallelism, or deploying worker threads to handle specific tasks based on the assigned values in the configuration. But, sometimes replication lag and other issues can...
How to Identify PostgreSQL Performance Issues with Slow Queries
When working with OLTP (OnLine Transaction Processing) databases, query performance is paramount as it directly impacts the user experience. Slow queries mean that the application feels unresponsive and slow and this results in bad conversion...
My PostgreSQL Database is Out of Disk Space
Disk space is a demanding resource nowadays. You usually will want to store data as long as possible, but this could be a problem if you don’t take the necessary actions to prevent a potential...
What to Check if PostgreSQL Memory Utilization is High
Reading from memory will always be more performant than going to disk, so for all database technologies you would want to use as much memory as possible. If you are not sure about the configuration,...
Migrating PostgreSQL to the Cloud – Comparing Solutions from Amazon, Google & Microsoft
From a bird’s eye view, it would appear that when it comes to migrating the PostgreSQL workloads into the cloud, the choice of cloud provider should make no difference. Out of the box, PostgreSQL makes...