Day: October 21, 2023

Enterprise PostgreSQL Solutions

1. Overview pg_basebackup is a powerful tool for creating physical backups of PostgreSQL database clusters. Unlike pg_dump, which generates logical backups, pg_basebackup captures the entire cluster state. These backups are crucial for point-in-time recovery or for setting up a standby server. 2. Backup Compression Efforts to enhance backup performance have