Groups > comp.databases.postgresql > #841

archiver problem

Newsgroups	comp.databases.postgresql
Date	2018-09-27 13:36 -0700
Message-ID	<3c7f141a-69cd-4d11-9d8d-d32d1c1a371b@googlegroups.com> (permalink)
Subject	archiver problem
From	Alf Normann Klausen <alf@svada.com>

Show all headers | View raw

Hi,

My postgres 9.6 master database is trying to archive a WAL file that does not exist anymore. In the log I find lots of this error:

< 2018-09-27 22:25:23.027 CEST     >WARNING:  archiving transaction log file "0000000300005770000000EB" failed too many times, will try again later
< 2018-09-27 22:25:23.215 CEST     >LOG:  archive command failed with exit code 23
< 2018-09-27 22:25:23.215 CEST     >DETAIL:  The failed archive command was: rsync -a pg_xlog/0000000300005770000000EB barman@192.168.4.52:/mnt/nfs/barman/datavarehus/incoming/0000000300005770000000EB

(I am running streaming replication and also barman, this is happening on my master).

Archive parameters in postgresql.conf

[postgres@datavarehus: ~]$ grep ^arch 9.6/data/postgresql.conf 
archive_mode = on
archive_command = 'rsync -a %p barman@192.168.4.52:/mnt/nfs/barman/datavarehus/incoming/%f'
[postgres@datavarehus: ~]$ 


How can I get out of this?

Kind regards, Alf

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

archiver problem Alf Normann Klausen <alf@svada.com> - 2018-09-27 13:36 -0700
  Re: archiver problem Laurenz Albe <laurenz@nospam.pn> - 2018-10-01 16:19 +0000
    Re: archiver problem Alf Normann Klausen <alf@svada.com> - 2018-10-02 03:59 -0700

csiph-web