Barman WAL Archive failed for server - please make sure WAL shipping is setup.
Armandt van Zyl
Giulio Calacoci
Is Barman's cron running?
Have you tried to issue the barman cron command manually?
Looks like that you PostgreSQL server archive_command is not copying
WAL files where barman expects them to be.
You can discover where barman expects the WAL files to be using the
barman show-server command.
Otherwise, could you please provide the output of the barman diagnose command?
Regards
Giulio
> --
> You received this message because you are subscribed to the "Barman for
> PostgreSQL" group.
> To post to this group, send email to pgba...@googlegroups.com
> To unsubscribe from this group, send email to
> pgbarman+u...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/pgbarman?hl=en?hl=en-GB
>
> ---
> You received this message because you are subscribed to the Google Groups
> "Barman, Backup and Recovery Manager for PostgreSQL" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to pgbarman+u...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
--
Giulio Calacoci - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
giulio....@2ndQuadrant.it | www.2ndQuadrant.it
Armandt van Zyl
Venky
Hi Giulio Calacoci,
[barman@localhost wals]$ barman diagnose
{
"global": {
"config": {
"barman_home": "/var/lib/barman",
"barman_user": "barman",
"compression": "gzip",
"errors_list": [],
"log_file": "/var/log/barman/barman.log",
"minimum_redundancy": "4",
"retention_policy": "RECOVERY WINDOW OF 4 WEEKS",
"reuse_backup": "link"
},
"system_info": {
"barman_ver": "2.3",
"kernel_ver": "Linux localhost.localdomain 3.10.0-514.el7.x86_64 #1 SMP Wed Oct 19 11:24:13 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "",
"release": "RedHat Linux Red Hat Enterprise Linux Server release 7.3 (Maipo)",
"rsync_ver": "rsync version 3.0.9 protocol version 30",
"ssh_ver": ""
}
},
"servers": {
"data": {
"backups": {},
"config": {
"active": true,
"archiver": true,
"archiver_batch_size": 0,
"backup_directory": "/var/lib/barman/data",
"backup_method": "rsync",
"backup_options": "exclusive_backup",
"bandwidth_limit": null,
"barman_home": "/var/lib/barman",
"barman_lock_directory": "/var/lib/barman",
"basebackup_retry_sleep": 30,
"basebackup_retry_times": 0,
"basebackups_directory": "/var/lib/barman/data/base",
"check_timeout": 30,
"compression": "gzip",
"conninfo": "host=localhost user=postgres",
"custom_compression_filter": null,
"custom_decompression_filter": null,
"description": "Essilor Production Databases",
"disabled": false,
"errors_directory": "/var/lib/barman/data/errors",
"immediate_checkpoint": false,
"incoming_wals_directory": "/var/lib/barman/data/incoming",
"last_backup_maximum_age": null,
"max_incoming_wals_queue": null,
"minimum_redundancy": 4,
"msg_list": [],
"name": "data",
"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": null,
"pre_archive_retry_script": null,
"pre_archive_script": null,
"pre_backup_retry_script": null,
"pre_backup_script": null,
"recovery_options": "",
"retention_policy": "window 4 w",
"retention_policy_mode": "auto",
"reuse_backup": "link",
"slot_name": null,
"ssh_command": "ssh postgres@localhost -q",
"streaming_archiver": false,
"streaming_archiver_batch_size": 0,
"streaming_archiver_name": "barman_receive_wal",
"streaming_backup_name": "barman_streaming_backup",
"streaming_conninfo": "host=localhost user=postgres",
"streaming_wals_directory": "/var/lib/barman/data/streaming",
"tablespace_bandwidth_limit": null,
"wal_retention_policy": "simple-wal 4 w",
"wals_directory": "/var/lib/barman/data/wals"
},
"status": {
"archive_command": "rsync -a %p barman@localhost:/var/lib/barman/data/wals/%f",
"archive_mode": "on",
"archived_count": 15,
"config_file": "/data1/pgsql_data/postgresql.conf",
"current_archived_wals_per_second": 2.16315154996823e-05,
"current_size": 37708788.0,
"current_xlog": "000000010000000000000011",
"data_directory": "/data1/pgsql_data",
"failed_count": 0,
"hba_file": "/data1/pgsql_data/pg_hba.conf",
"ident_file": "/data1/pgsql_data/pg_ident.conf",
"included_files": [
"/data1/pgsql_data/postgresql.auto.conf"
],
"is_archiving": true,
"is_in_recovery": false,
"is_superuser": true,
"last_archived_time": "Fri Oct 6 13:13:35 2017",
"last_archived_wal": "000000010000000000000011",
"last_failed_time": null,
"last_failed_wal": null,
"pgespresso_installed": false,
"replication_slot": null,
"replication_slot_support": true,
"server_txt_version": "9.5.8",
"stats_reset": "Thu Sep 28 12:38:10 2017",
"synchronous_standby_names": [
""
],
"wal_level": "archive"
},
"system_info": {
"kernel_ver": "Linux localhost.localdomain 3.10.0-514.el7.x86_64 #1 SMP Wed Oct 19 11:24:13 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "",
"release": "RedHat Linux Red Hat Enterprise Linux Server release 7.3 (Maipo)",
"rsync_ver": "rsync version 3.0.9 protocol version 30",
"ssh_ver": ""
},
"wals": {
"last_archived_wal_per_timeline": null
}
}
}
}
Thanks for your help in advance.
giulio.calacoci@2ndQuadrant.it | www.2ndQuadrant.it
