thanks Alvaro, following your instructions I solved the problem. Il 01/04/2020 19:36, Alvaro Herrera ha scritto: > On 2020-Apr-01, Silvio Fabi - NBS srl wrote: > >> 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@database:/var/lib/barman/database/incoming/000000010000020A00000073 > Ouch. This is not a barman problem; accidentally a WAL file is > synonymous with corrupting your database. Any existing backup that > needs that file is now invalid. I suggest you run CHECKPOINT and then > take a new backup. I think removing the 000000010000020A00000073.ready > file from pg_wal should prevent future attempts at archiving it, so that > subsequent WAL files are archived. > > By all means, *do not* lose any more WAL files. It is a very dangerous > thing to do. >
-- Silvio Fabi NBS srl Via Val Tiberina 23/A San Benedetto del Tronto (AP) Telefono: 0735/7626242 Cellulare: 345/0142435
