postgres: archiver process failed on 000000010000020A00000073

From: Silvio Fabi - NBS srl <s(dot)fabi(at)nbsgroup(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres: archiver process failed on 000000010000020A00000073
Date: 2020-04-01 17:09:59
Message-ID: 8e9bfb6a-a8c6-0ff5-b1e2-346f3db260dd@nbsgroup.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

WAL Archive process on my DB Postgresql 10 is not working.
the WAL Archive file 000000010000020A00000073 was accidentally deleted
and there is no backup.
Postgresql tries to run the following command:
rsync -a pg_wal/000000010000020A00000073
barman(at)database:/var/lib/barman/database/incoming/000000010000020A00000073

but of course it fails

below the message in the postgres log file:
2020-04-01 18:48:19 CEST [18265]: [101016-1] DETAIL:  The failed archive
command was: rsync -a pg_wal/000000010000020A00000073
barman(at)database:/var/lib/barman/database/incoming/000000010000020A00000073
2020-04-01 18:48:19 CEST [18265]: [101017-1] WARNING:  archiving
write-ahead log file "000000010000020A00000073" failed too many times,
will try again later

Postgresql continues to generate WALs Archive file in local directory
"log" and I have no application problems, but continuous archiving on
the barman repository does not work.

How can I fix this problem?

--
Silvio Fabi
NBS srl
Via Val Tiberina 23/A
San Benedetto del Tronto (AP)
Telefono: 0735/7626242
Cellulare: 345/0142435

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2020-04-01 17:36:06 Re: postgres: archiver process failed on 000000010000020A00000073
Previous Message Roberto Della Pasqua 2020-04-01 16:33:18 R: dbeaver