Fri.Dec 23, 2022

Remove -open-source
article thumbnail

Diffing PostgreSQL Schema Changes

Percona

In regards to open source solutions, there are a number of projects capable of diffing Postgres database schemas. The following is an example implementation of the open source tool apgdiff. . Researching, ala Google, yields the most popular technologies one can use. Working with the apgdiff extension.

article thumbnail

Rebuild Patroni Replica Using pgBackRest

Percona

Both these open source tools have been saviors for DBAs for achieving high availability and performing restoration in ample ways. This is one of the most used backup tool used for PostgreSQL databases. In the previous blogs, we have discussed how to set up PostgreSQL HA with Patroni , and how to configure pgBackRest.