I am facing BARMAN backup issue in EDB postgresql 16 database.
1> For taking incremental backup,I had changed backup_method in barman.conf file from postgres to rsync. Kept any other parameter same
[root@innolx4057 barman.d]# cat my_postgres_server.conf
[my_postgres_server]
description = "My PostgreSQL Server"
ssh_command = ssh dnb-reporting@10.184.40.57
conninfo = host=10.184.40.57 user=barman dbname=dnb-reporting port=5444
#streaming_conninfo = host=10.184.40.57 user=barman
#backup_method = postgres
backup_method = rsync
streaming_archiver = on
retention_policy = RECOVERY WINDOW OF 7 DAYS
#archiver = on
slot_name = barman
create_slot = auto
and then tried backup But getting below error
[barman@innolx4057 ~]$ barman cron
WARNING: No backup strategy set for server 'my_postgres_server' (using default 'concurrent_backup').
Starting WAL archiving for server my_postgres_server
[barman@innolx4057 ~]$ barman check all
WARNING: No backup strategy set for server 'my_postgres_server' (using default 'concurrent_backup').
Server my_postgres_server:
ssh: FAILED (Connection failed using 'ssh dnb-reporting@10.184.40.57 -o BatchMode=yes -o StrictHostKeyChecking=no' return code 255)
archiver errors: FAILED (duplicates: 1)
** Kindly suggest what I am doing wrong here. Reverting from rsync to postgres again running the backup successfully**
############################################################
2> After I switchover, I am facing issue to run backup (with backup_method=postgres)
[barman@innolx4058 ~]$ barman backup --reuse-backup=off --name backup_20250528_full_1 my_postgres_server
ERROR: Impossible to start the backup. Check the log for more details, or run 'barman check my_postgres_server'
2025-05-28 13:54:17,143 barman.command_wrappers INFO: my_postgres_server: pg_receivewal: starting log streaming at 1/24000000 (timeline 1)
2025-05-28 13:54:17,144 barman.command_wrappers INFO: my_postgres_server: pg_receivewal: error: could not send replication command "START_REPLICATION": ERROR: requested starting point 1/24000000 on timeline 1 is not in this server's history
2025-05-28 13:54:17,144 barman.command_wrappers INFO: my_postgres_server: DETAIL: This server's history forked from timeline 1 at 0/410000A0.
2025-05-28 13:54:17,145 barman.command_wrappers INFO: my_postgres_server: pg_receivewal: error: disconnected
2025-05-28 13:54:17,147 barman.server ERROR: ArchiverFailure:pg_receivewal terminated with error code: 1
2025-05-28 13:54:24,389 barman.server ERROR: Check 'replication slot' failed for server 'my_postgres_server'
2025-05-28 13:54:24,392 barman.server ERROR: Check 'receive-wal running' failed for server 'my_postgres_server'
2025-05-28 13:54:30,722 barman.server ERROR: Check 'replication slot' failed for server 'my_postgres_server'
2025-05-28 13:54:30,724 barman.server ERROR: Check 'receive-wal running' failed for server 'my_postgres_server'
2025-05-28 13:54:30,725 barman.server ERROR: Impossible to start the backup. Check the log for more details, or run 'barman check my_postgres_server'
2025-05-28 13:55:02,140 barman.utils INFO: Cleaning up lockfiles directory.
2025-05-28 13:55:02,315 barman.wal_archiver INFO: No xlog segments found from streaming for my_postgres_server.
2025-05-28 13:55:02,401 barman.server INFO: Starting receive-wal for server my_postgres_server
2025-05-28 13:55:02,403 barman.server ERROR: ArchiverFailure:pg_receivewal not present in $PATH
I tried:
[barman@innolx4058 ~]$ which pg_receivewal
/usr/edb/as16/bin/pg_receivewal
[barman@innolx4058 ~]$ barman switch-wal --archive --archive-timeout 60 my_postgres_server
No switch required for server 'my_postgres_server'
Waiting for a WAL file from server 'my_postgres_server' to be archived (max: 60 seconds)
^CERROR: Process interrupted by user (KeyboardInterrupt)
[barman@innolx4058 ~]$ barman receive-wal my_postgres_server
Starting receive-wal for server my_postgres_server
my_postgres_server: pg_receivewal: starting log streaming at 1/24000000 (timeline 1)
my_postgres_server: pg_receivewal: error: could not send replication command "START_REPLICATION": ERROR: requested starting point 1/24000000 on timeline 1 is not in this server's history
my_postgres_server: DETAIL: This server's history forked from timeline 1 at 0/410000A0.
my_postgres_server: pg_receivewal: error: disconnected
ERROR: ArchiverFailure:pg_receivewal terminated with error code: 1
Asked by Cassandra Thrift
(307 rep)
May 28, 2025, 09:27 AM