Re: Barman backup fails after upgrade to PostgreSQL 10

Поиск
Список
Период
Сортировка
От Flavio Henrique Araque Gurgel
Тема Re: Barman backup fails after upgrade to PostgreSQL 10
Дата
Msg-id CAGHTAePuHRF-1B5mQnxiuK+KEso0nqTsZB===QbaZ5Qp+iUsng@mail.gmail.com
обсуждение исходный текст
Ответ на Barman backup fails after upgrade to PostgreSQL 10  (Marco DE BOOIJ <marco.maillist@debooy.eu>)
Список pgsql-admin


Em dom, 18 de mar de 2018 12:22, Marco DE BOOIJ <marco.maillist@debooy.eu> escreveu:
After my upgrade of PostgreSQL 9.6 to 10.3 the backups through barman
fails. There is not much data change in the database but I still do not
want to loose the data. I have verified the configuration and all seems
correct for Barman and PostgreSQL . I have tried to find the answer on
the internet but I was not able to find it. Both Barman and PostgreSQL
run on the same server.

PostgreSQL    : 10.3 (Debian 10.3-1.pgdg90+1)
Barman          :  2.3
Debian           :  9.4

Configuration for the database in /etc/barman.d

description = "Productie PostgreSQL Database"
conninfo = host=maat user=barman dbname=postgres
streaming_conninfo = host=maat user=streaming_barman
backup_method = postgres
streaming_archiver = on
slot_name = barman
retention_policy = RECOVERY WINDOW OF 4 WEEKS

When I run 'barman backup all' I get the following output:

ERROR: Backup failed copying files.
DETAILS: data transfer failure on directory '/srv/share/backup/barman/maat/base/20180317T233002/data'
pg_basebackup error:
pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 2/B000028 on timeline 1
pg_basebackup: starting background WAL receiver
pg_basebackup: could not connect to server: FATAL:  number of requested standby connections exceeds max_wal_senders (currently 2)
pg_basebackup: removing contents of data directory "/srv/share/backup/barman/maat/base/20180317T233002/data"
Starting backup using postgres method for server maat in /srv/share/backup/barman/maat/base/20180317T233002
Backup start at LSN: 2/A1F2CF0 (00000001000000020000000A, 001F2CF0)
Starting backup copy via pg_basebackup for 20180317T233002
maat 20180317T233002 - FAILED

In the barman.log there are the following lines around this message (indicated with ....):

2018-03-17 23:29:02,673 [15604] barman.wal_archiver INFO: No xlog segments found from streaming for maat.
2018-03-17 23:30:02,107 [15646] barman.wal_archiver INFO: Synchronous WAL streaming for barman_receive_wal: False
2018-03-17 23:30:02,326 [15646] barman.server INFO: Ignoring failed check 'backup maximum age' for server 'maat'
2018-03-17 23:30:02,359 [15648] barman.wal_archiver INFO: No xlog segments found from streaming for maat.
2018-03-17 23:30:02,560 [15646] barman.backup INFO: Starting backup using postgres method for server maat in /srv/share/backup/barman/maat/base/20180317T233002
2018-03-17 23:30:02,662 [15646] barman.backup_executor INFO: Backup start at LSN: 2/A1F2CF0 (00000001000000020000000A, 001F2CF0)
2018-03-17 23:30:02,666 [15646] barman.backup_executor INFO: Starting backup copy via pg_basebackup for 20180317T233002
2018-03-17 23:30:04,069 [15646] barman.backup ERROR: Backup failed copying files.
....
2018-03-17 23:30:04,870 [15646] barman.wal_archiver INFO: No xlog segments found from streaming for maat.
2018-03-17 23:30:05,188 [2390] barman.command_wrappers INFO: maat: pg_receivewal: finished segment at 2/B000000 (timeline 1)
2018-03-17 23:31:02,041 [15691] barman.wal_archiver INFO: Found 1 xlog segments from streaming for maat. Archive all segments in one run.
2018-03-17 23:31:02,042 [15691] barman.wal_archiver INFO: Archiving segment 1 of 1 from streaming: maat/00000001000000020000000A
2018-03-17 23:32:02,640 [15708] barman.wal_archiver INFO: No xlog segments found from streaming for maat.

Upgrade the postgresql-client package on you barman sever. Upgrade barman also to the latest version.

If the error persists, consider removing any files remaining in the server's folder streaming subdirectory and check if your slot exists in the PostgreSQL server.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Marco DE BOOIJ
Дата:
Сообщение: Barman backup fails after upgrade to PostgreSQL 10
Следующее
От: "Georg H."
Дата:
Сообщение: Re: Barman backup fails after upgrade to PostgreSQL 10