by Bhargav Kamineni | Dec 14, 2023 | Insight for DBAs, PostgreSQL
While a hallmark feature of PostgreSQL is streaming replication, sometimes data demands a more refined and adaptable replication approach to address different requirements. Logical replication offers a distinct advantage over traditional streaming replication by... by Bhargav Kamineni | May 8, 2023 | Insight for DBAs, PostgreSQL
In simpler terms, logical replication in PostgreSQL is a way to copy data from one database to another in a more flexible and customizable manner compared to physical replication. Instead of copying the entire database, logical replication focuses on replicating... by Bhargav Kamineni | Nov 15, 2022 | Insight for DBAs, PostgreSQL
In one of our previous posts—pgBackRest: A Great Backup Solution and a Wonderful Year of Growth—we discussed the installation of pgBackRest and the backup, quick restore command. It would be ideal to have a restoration activity scheduled as per business...