Good morning guys. I have a backup that doesn't finish and I'm getting the following error:
Asking the PostgreSQL server to finish the backup.
minimum redundancy requirements: OK (there are 0 backups, at least 0 expected)
[barman@barman02:~/log$] barman diagnose
[WARNING: The default backup strategy will change to 'concurrent_backup' in the future. Explicitly set 'backup_options' to silence this warning.
{
"global": {
"config": {
"barman_home": "/opt/barman/backups",
"barman_user": "barman",
"basebackup_retry_sleep": "30",
"basebackup_retry_times": "3",
"compression": "bzip2",
"configuration_files_directory": "/opt/barman/etc",
"errors_list": [],
"immediate_checkpoint": "true",
"log_file": "/opt/barman/log/barman.log",
"network_compression": "true",
"post_backup_script": "/opt/barman/bin/backup_check.sh",
"pre_backup_script": "/opt/barman/bin/backup_check.sh",
"reuse_backup": "link"
},
"system_info": {
"barman_ver": "2.18",
"kernel_ver": "Linux barman02.xxx.xx 3.10.0-1160.24.1.el7.x86_64 #1 SMP Thu Apr 8 19:51:47 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "",
"release": "LSB Version:\t:core-4.1-amd64:core-4.1-noarch\nDistributor ID:\tCentOS\nDescription:\tCentOS Linux release 7.9.2009 (Core)\nRelease:\t7.9.2009\nCodename:\tCore",
"rsync_ver": "rsync version 3.1.2 protocol version 31",
"ssh_ver": "",
"timestamp": "Fri Mar 4 08:31:30 2022"
}
},
"servers": {
"bidb": {
"backups": {},
"config": {
"active": true,
"archiver": true,
"archiver_batch_size": 0,
"backup_directory": "/opt/barman/backups/bidb",
"backup_method": "rsync",
"backup_options": "concurrent_backup",
"bandwidth_limit": null,
"barman_home": "/opt/barman/backups",
"barman_lock_directory": "/opt/barman/backups",
"basebackup_retry_sleep": 30,
"basebackup_retry_times": 3,
"basebackups_directory": "/opt/barman/backups/bidb/base",
"check_timeout": 30,
"compression": "bzip2",
"conninfo": "host=bidb.xxx.xx port=5445 user=BI password=*REDACTED* dbname=ASBI1",
"create_slot": "manual",
"custom_compression_filter": null,
"custom_compression_magic": null,
"custom_decompression_filter": null,
"description": "BI Production PostgreSQL Database",
"disabled": false,
"errors_directory": "/opt/barman/backups/bidb/errors",
"forward_config_path": false,
"immediate_checkpoint": true,
"incoming_wals_directory": "/opt/barman/backups/bidb/incoming",
"last_backup_maximum_age": null,
"last_backup_minimum_size": null,
"last_wal_maximum_age": null,
"max_incoming_wals_queue": null,
"minimum_redundancy": 0,
"msg_list": [],
"name": "bidb",
"network_compression": false,
"parallel_jobs": 1,
"path_prefix": null,
"post_archive_retry_script": null,
"post_archive_script": null,
"post_backup_retry_script": null,
"post_backup_script": "/opt/barman/bin/backup_check.sh",
"post_delete_retry_script": null,
"post_delete_script": null,
"post_recovery_retry_script": null,
"post_recovery_script": null,
"post_wal_delete_retry_script": null,
"post_wal_delete_script": null,
"pre_archive_retry_script": null,
"pre_archive_script": null,
"pre_backup_retry_script": null,
"pre_backup_script": "/opt/barman/bin/backup_check.sh",
"pre_delete_retry_script": null,
"pre_delete_script": null,
"pre_recovery_retry_script": null,
"pre_recovery_script": null,
"pre_wal_delete_retry_script": null,
"pre_wal_delete_script": null,
"primary_ssh_command": null,
"recovery_options": "",
"retention_policy": "redundancy 1 b",
"retention_policy_mode": "auto",
"reuse_backup": "link",
"slot_name": null,
"ssh_command": "ssh enterp...@bidb.xxx.xx",
"streaming_archiver": false,
"streaming_archiver_batch_size": 0,
"streaming_archiver_name": "barman_receive_wal",
"streaming_backup_name": "barman_streaming_backup",
"streaming_conninfo": "host=bidb.xxx.xx port=5445 user=BI password=*REDACTED* dbname=ASBI1",
"streaming_wals_directory": "/opt/barman/backups/bidb/streaming",
"tablespace_bandwidth_limit": null,
"wal_retention_policy": "simple-wal 1 b",
"wals_directory": "/opt/barman/backups/bidb/wals"
},
"status": {
"archive_command": "/usr/bin/rsync -a %p bar...@barman02.xxx.xx:/opt/barman/backups/bidb/incoming/%f",
"archive_mode": "on",
"archive_timeout": 0,
"archived_count": 6311,
"checkpoint_timeout": 1200,
"config_file": "/opt/pgsql/9.6/data/postgresql.conf",
"current_archived_wals_per_second": 0.0736564302833114,
"current_lsn": "A610/FC9DB0B0",
"current_size": 5882648667004.0,
"current_xlog": "000000010000A610000000FC",
"data_checksums": "off",
"data_directory": "/opt/pgsql/9.6/data",
"failed_count": 0,
"has_backup_privileges": true,
"hba_file": "/opt/pgsql/9.6/data/pg_hba.conf",
"hot_standby": "on",
"ident_file": "/opt/pgsql/9.6/data/pg_ident.conf",
"included_files": [
"/opt/pgsql/9.6/data/postgresql.auto.conf",
"/opt/pgsql/9.6/data/postgresql-backend_params.conf",
"/opt/pgsql/9.6/data/postgresql-ssl_params.conf"
],
"is_archiving": true,
"is_in_recovery": false,
"is_superuser": true,
"last_archived_time": "Fri Mar 4 08:30:41 2022",
"last_archived_wal": "000000010000A610000000FB",
"last_failed_time": null,
"last_failed_wal": null,
"max_replication_slots": "3",
"max_wal_senders": "5",
"pgespresso_installed": false,
"postgres_systemid": "6489016419990633760",
"replication_slot": null,
"replication_slot_support": true,
"server_txt_version": "9.6.22",
"stats_reset": "Thu Mar 3 08:43:35 2022",
"synchronous_standby_names": [
""
],
"wal_compression": "off",
"wal_keep_segments": "12",
"wal_level": "replica",
"xlog_segment_size": 16777216
},
"system_info": {
"kernel_ver": "Linux bidb.xxx.xx 3.10.0-1160.49.1.el7.x86_64 #1 SMP Tue Nov 30 15:51:32 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "",
"release": "RedHat Linux CentOS Linux release 7.9.2009 (Core)",
"rsync_ver": "rsync version 3.1.2 protocol version 31",
"ssh_ver": ""
},
"wals": {
"last_archived_wal_per_timeline": {
"00000001": {
"compression": "bzip2",
"name": "000000010000A610000000FB",
"size": 4093211,
"time": 1646379040.493115
}
}
}
},
}
}
}
}
}
}
Client:
[root@bidb xxxxxxxxxx]# rpm -qa |grep barman
No packages
The barman diagnose command has minor modifications for confidentiality.
Thank you all for your help. I'm learning a lot and I like this group more and more every day. I hope that soon I can help and contribute my little knowledge.