1

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 [1545268] barman.command_wrappers INFO: my_postgres_server: pg_receivewal: starting log streaming at 1/24000000 (timeline 1) 2025-05-28 13:54:17,144 [1545268] 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 [1545268] 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 [1545268] barman.command_wrappers INFO: my_postgres_server: pg_receivewal: error: disconnected 2025-05-28 13:54:17,147 [1545268] barman.server ERROR: ArchiverFailure:pg_receivewal terminated with error code: 1 2025-05-28 13:54:24,389 [1545276] barman.server ERROR: Check 'replication slot' failed for server 'my_postgres_server' 2025-05-28 13:54:24,392 [1545276] barman.server ERROR: Check 'receive-wal running' failed for server 'my_postgres_server' 2025-05-28 13:54:30,722 [1545282] barman.server ERROR: Check 'replication slot' failed for server 'my_postgres_server' 2025-05-28 13:54:30,724 [1545282] barman.server ERROR: Check 'receive-wal running' failed for server 'my_postgres_server' 2025-05-28 13:54:30,725 [1545282] 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 [1545323] barman.utils INFO: Cleaning up lockfiles directory. 2025-05-28 13:55:02,315 [1545324] barman.wal_archiver INFO: No xlog segments found from streaming for my_postgres_server. 2025-05-28 13:55:02,401 [1545325] barman.server INFO: Starting receive-wal for server my_postgres_server 2025-05-28 13:55:02,403 [1545325] 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

0 Answers0