Les paso el diagnose y el contenido del archivo de configuración del server
santacruz
A pesar de que todo parece funcionar bien, el log sigue mostrando el error
mencionado.
/etc/braman.d/santacruz.conf
[santacruz]
description = "PJud de Santa Cruz Pg (via SSH)"
backup_directory = /home/barman/santacruz
ssh_command = ssh postgres@192.168.172.33
conninfo = host=192.168.172.33 port=5432 user=barman password=xxx
dbname=postgres
backup_method = rsync
streaming_archiver = off
archiver = on
El mié, 13 mar 2024 a las 13:08, Jaime Soler (<jaime.so...@gmail.com>)
escribió:
> ¿ Puedes compartir la salida de barman diagnose y la configuración del
> fichero de backup de tu servidor que se guarda dentro de /etc/barman.d ? ,
> parece como si no parseara bien alguno de los ficheros de configuración y
> lo que compartiste parece que está bien, por eso te pido el otro fichero.
>
> Un saludo
>
> El mié, 13 mar 2024 a las 14:24, Guillermo E. Villanueva (<
> guillermo...@gmail.com>) escribió:
>
>> Hola buen día, en un debian 11 instalé barman 3.10, ya lo configuré para
>> backups con rsync y parece que va todo ok, los wal llegan correctamente y
>> el primer full funcionó correctamente pero en el log de barman, cada minuto
>> tengo el siguiente error:
>>
>> ..... [3029] barman.config ERROR: Cannot execute None: Expecting value:
>> line 1 column 1 (char 0)
>>
>> El archivo barman.conf tiene lo siguiente:
>> [barman]
>> barman_user = barman
>> configuration_files_directory = /etc/barman.d
>> backup_options = exclusive_backup
>> reuse_backup = link
>> barman_home = /var/lib/barman
>> log_file = /var/log/barman/barman.log
>> log_level = ERROR
>> compression = gzip
>> immediate_checkpoint = true
>> basebackup_retry_times = 3
>> basebackup_retry_sleep = 30
>> last_backup_maximum_age = 7 DAYS
>> retention_policy = RECOVERY WINDOW OF 3 WEEKS
>>
>> barman check all tambien me da todo ok.
>>
>> ¿Qué podrá ser lo del error que muestra el log?
>> Desde ya muchas gracias!
>>
>>
{
"global": {
"config": {
"backup_options": "exclusive_backup",
"barman_home": "/var/lib/barman",
"barman_user": "barman",
"basebackup_retry_sleep": "30",
"basebackup_retry_times": "3",
"compression": "gzip",
"configuration_files_directory": "/etc/barman.d",
"errors_list": [],
"immediate_checkpoint": "true",
"last_backup_maximum_age": "7 DAYS",
"log_file": "/var/log/barman/barman.log",
"log_level": "ERROR",
"retention_policy": "RECOVERY WINDOW OF 3 WEEKS",
"reuse_backup": "link"
},
"system_info": {
"barman_ver": "3.10.0",
"kernel_ver": "Linux Debian-05-V11 5.10.0-28-amd64 #1 SMP Debian
5.10.209-2 (2024-01-31) x86_64 GNU/Linux",
"python_ver": "",
"release": "Distributor ID:\tDebian\nDescription:\tDebian GNU/Linux
11 (bullseye)\nRelease:\t11\nCodename:\tbullseye",
"rsync_ver": "rsync version 3.2.3 protocol version 31",
"ssh_ver": "",
"timestamp": "2024-03-14T10:19:37.108502-03:00"
}
},
"models": {},
"servers": {
"santacruz": {
"active_model": null,
"backups": {
"20240313T101426": {
"backup_id": "20240313T101426",
"backup_label": null,
"begin_offset": 40,
"begin_time": "2024-03-13T10:14:26.127719-03:00",
"begin_wal": "000000010000002D00000049",
"begin_xlog": "2D/49000028",
"compression": null,
"config_file": "/etc/postgresql/14/main/postgresql.conf",
"copy_stats": {
"analysis_time": 0.801669,
"analysis_time_per_item": {
"pgdata": 0.801669
},
"copy_time": 111.603679,
"copy_time_per_item": {
"config_file": 0.189547,
"hba_file": 0.190319,
"ident_file": 0.188415,
"pg_control": 0.185261,
"pgdata": 110.845212
},
"number_of_workers": 1,
"serialized_copy_time": 111.532835,
"serialized_copy_time_per_item": {
"config_file": 0.189547,
"hba_file": 0.190319,
"ident_file": 0.188415,
"pg_control": 0.185261,
"pgdata": 110.779293
},
"total_time": 112.474005
},
"deduplicated_size": 14030989187,
"end_offset": 1954448,
"end_time": "2024-03-13T10:16:18.829234-03:00",
"end_wal": "000000010000002D00000049",
"end_xlog": "2D/491DD290",
"error": null,
"hba_file": "/etc/postgresql/14/main/pg_hba.conf",
"ident_file": "/etc/postgresql/14/main/pg_ident.conf",
"included_files": null,
"mode": "rsync-exclusive",
"pgdata": "/var/lib/postgresql/14/main",
"server_name": "santacruz",
"size": 14030989187,
"status": "DONE",
"systemid": "7114430912595421644",
"tablespaces": null,
"timeline": 1,
"version": 140004,
"xlog_segment_size": 16777216
}
},
"config": {
"active": true,
"archiver": true,
"archiver_batch_size": 0,
"autogenerate_manifest": false,
"aws_profile": null,
"aws_region": null,
"azure_credential": null,
"azure_resource_group": null,
"azure_subscription_id": null,
"backup_compression": null,
"backup_compression_format": null,
"backup_compression_level": null,
"backup_compression_location": null,
"backup_compression_workers": null,
"backup_directory": "/home/barman/santacruz",
"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": 3,
"basebackups_directory": "/home/barman/santacruz/base",
"check_timeout": 30,
"cluster": "santacruz",
"compression": "gzip",
"config_changes_queue": "/var/lib/barman/cfg_changes.queue",
"conninfo": "host=192.168.172.33 port=5432 user=barman
password=*REDACTED* dbname=postgres",
"create_slot": "manual",
"custom_compression_filter": null,
"custom_compression_magic": null,
"custom_decompression_filter": null,
"description": "PJud de Santa Cruz Pg (via SSH)",
"disabled": false,
"errors_directory": "/home/barman/santacruz/errors",
"forward_config_path": false,
"gcp_project": null,
"gcp_zone": null,
"immediate_checkpoint": true,
"incoming_wals_directory": "/home/barman/santacruz/incoming",
"last_backup_maximum_age": "7 days",
"last_backup_minimum_size": null,
"last_wal_maximum_age": null,
"lock_directory_cleanup": true,
"max_incoming_wals_queue": null,
"minimum_redundancy": 0,
"msg_list": [],
"name": "santacruz",
"network_compression": false,
"parallel_jobs": 1,
"parallel_jobs_start_batch_period": 1,
"parallel_jobs_start_batch_size": 10,
"path_prefix": null,
"post_archive_retry_script": null,
"post_archive_script": null,
"post_backup_retry_script": null,
"post_backup_script": null,
"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": null,
"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_checkpoint_timeout": 0,
"primary_conninfo": null,
"primary_ssh_command": null,
"recovery_options": "",
"recovery_staging_path": null,
"retention_policy": "window 3 w",
"retention_policy_mode": "auto",
"reuse_backup": "link",
"slot_name": null,
"snapshot_disks": null,
"snapshot_gcp_project": null,
"snapshot_instance": null,
"snapshot_provider": null,
"snapshot_zone": null,
"ssh_command": "ssh postgres@192.168.172.33",
"streaming_archiver": false,
"streaming_archiver_batch_size": 0,
"streaming_archiver_name": "barman_receive_wal",
"streaming_backup_name": "barman_streaming_backup",
"streaming_conninfo": "host=192.168.172.33 port=5432
user=barman password=*REDACTED* dbname=postgres",
"streaming_wals_directory": "/home/barman/santacruz/streaming",
"tablespace_bandwidth_limit": null,
"wal_conninfo": null,
"wal_retention_policy": "simple-wal 3 w",
"wal_streaming_conninfo": null,
"wals_directory": "/home/barman/santacruz/wals"
},
"status": {
"archive_command": "rsync -a %p
barman@192.168.172.36:/home/barman/santacruz/incoming/%f",
"archive_mode": "on",
"archive_timeout": 0,
"archived_count": 47,
"checkpoint_timeout": 300,
"config_file": "/etc/postgresql/14/main/postgresql.conf",
"current_archived_wals_per_second": 9.192878219912067e-07,
"current_lsn": "2D/6628DEA8",
"current_size": 14046178123.0,
"current_xlog": "000000010000002D00000066",
"data_checksums": "off",
"data_directory": "/var/lib/postgresql/14/main",
"failed_count": 252,
"has_backup_privileges": true,
"has_monitoring_privileges": true,
"hba_file": "/etc/postgresql/14/main/pg_hba.conf",
"hot_standby": "on",
"ident_file": "/etc/postgresql/14/main/pg_ident.conf",
"is_archiving": true,
"is_in_recovery": false,
"is_superuser": true,
"last_archived_time": "2024-03-14T10:15:32.104328-03:00",
"last_archived_wal": "000000010000002D00000065",
"last_failed_time": "2024-03-14T00:07:32.521702-03:00",
"last_failed_wal": "000000010000002D00000058",
"max_replication_slots": "6",
"max_wal_senders": "10",
"postgres_systemid": "7114430912595421644",
"replication_slot": null,
"replication_slot_support": true,
"server_txt_version": "14.4",
"stats_reset": "2022-07-28T22:30:44.359361-03:00",
"synchronous_standby_names": [
""
],
"version_supported": true,
"wal_compression": "off",
"wal_keep_size": "0",
"wal_level": "replica",
"xlog_segment_size": 16777216
},
"system_info": {
"kernel_ver": "Linux Debian-03-V11 5.10.0-23-amd64 #1 SMP
Debian 5.10.179-1 (2023-05-12) x86_64 GNU/Linux",
"python_ver": "",
"release": "Distributor ID:\tDebian\nDescription:\tDebian
GNU/Linux 11 (bullseye)\nRelease:\t11\nCodename:\tbullseye",
"rsync_ver": "rsync version 3.2.3 protocol version 31",
"ssh_ver": ""
},
"wals": {
"last_archived_wal_per_timeline": {
"00000001": {
"compression": "gzip",
"name": "000000010000002D00000065",
"size": 7563136,
"time": 1710422131.7301822
}
}
}
}
}
}
