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. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
