Search Postgresql Archives

postgres: archiver process failed on 000000010000020A00000073

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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@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








[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux