Sobes.tech
Middle

What tools do you use to back up the cluster?

sobes.tech AI

Answer from AI

The following tools are often used for PostgreSQL cluster backups:

  • pg_basebackup — a built-in tool for creating a physical copy of the entire cluster, suitable for basic backups.
  • pg_dump/pg_dumpall — for logical backups of individual databases or the entire cluster.
  • Barman — a specialized tool for managing backups and restoring PostgreSQL, supporting incremental backups and WAL archiving.
  • Wal-G — a modern backup tool with support for cloud storage, effective for large data volumes.
  • Patroni + Etcd/Consul — for cluster management and ensuring high availability, in conjunction with backups.

Depending on RTO/RPO requirements and infrastructure, a combination of these tools is chosen. For critical systems, pg_basebackup with WAL archiving via Barman or Wal-G is used to ensure precise recovery up to the point of failure.