Re: postgres: archiver process failed on 000000010000020A00000073

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(at)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