Groups > comp.databases.postgresql > #841

archiver problem

X-Received	by 2002:a37:7844:: with SMTP id t65-v6mr5938670qkc.36.1538080594303; Thu, 27 Sep 2018 13:36:34 -0700 (PDT)
X-Received	by 2002:a81:2b43:: with SMTP id r64-v6mr135781ywr.1.1538080594008; Thu, 27 Sep 2018 13:36:34 -0700 (PDT)
Path	csiph.com!xmission!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!m93-v6no674750qte.0!news-out.google.com!k67-v6ni1031qte.1!nntp.google.com!m93-v6no674747qte.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.postgresql
Date	Thu, 27 Sep 2018 13:36:33 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=2001:4644:fc44:0:acc1:de86:3a1:1060; posting-account=n0QKOAoAAAAyY9TgRFDUxAam8YMCt_At
NNTP-Posting-Host	2001:4644:fc44:0:acc1:de86:3a1:1060
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<3c7f141a-69cd-4d11-9d8d-d32d1c1a371b@googlegroups.com> (permalink)
Subject	archiver problem
From	Alf Normann Klausen <alf@svada.com>
Injection-Date	Thu, 27 Sep 2018 20:36:34 +0000
Content-Type	text/plain; charset="UTF-8"
Lines	20
Xref	csiph.com comp.databases.postgresql:841

Show key headers only | 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