I am taking backups of my PostgreSQL database with PgBackrest, performing a full backup once a week and incremental backups for five days.
I store the backups on a separate backup server, apart from my production server. However, my backup files are taking up more than twice the space of my production database.
Production database disk information:
enter image description here
Backup disk information:
enter image description here
Backup archive and backup folder size information:
enter image description here
Prod Server bcbackrest config information;
[global]
log-level-file=info
repo1-host=(backup_server_hostname)
archive-async = y
process-max = 2
spool-path = /var/spool/pgbackrest
[global:archive-get]
process-max=8
[global:archive-push]
process-max=8
[my_stanza]
pg1-path=/cluster_path
pg1-port=cluster_port
Backup Server bcbackrest config information;
[global]
repo1-path=/backup_path
repo1-retention-full=1
process-max=8
start-fast=y
log-level-console=info
log-level-file=info
[my_stanza]
pg1-host=(prod_server_hostname)
pg1-path=/cluster_path
pg1-port=cluster_port
The size of the “Archive” file on my backup server is very large. Besides that, my “Backup” file seems to be larger than necessary. What should I do?
Thanks.