Is it possible to configure pgbackrest for a postgresql server pair using physical replication on two different sites with limited bandwidth (i.e. sufficient for data replication but not daily backups)? All tutorials and blogs describe a setup with either a single pgbackrest repo or multiple repos configured on the primary server. I am looking for a solution that has a second pgbackrest server on a secondary site that receives backups and WALs from the standby server in order to avoid most of the additional network traffic for backups/WALs. Is such a setup possible with pgbackrest or other PostgreSQL backups solutions?
