RE: pgbackrest archive-push exit code 25

I ended up solving it by turning archiving off and back on in postgresql.conf to purge the offending forward file ... its an analysis database, so I can restart PostgreSQL at my leisure most of the time ... AND setting up pgbackrest properly on the remote server instead of just via sshfs.

Thanks for the help.

--Stephen

-----Original Message-----
From: Stephen Frost <sfrost(at)snowman(dot)net>
Sent: Friday, May 18, 2018 19:04
To: Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: pgbackrest archive-push exit code 25

Greetings,

* Stephen Froehlich (s(dot)froehlich(at)cablelabs(dot)com) wrote:
> I am in the process of getting pgbackrest up and running on my analysis server, and I keep on getting the following but can't find a reference for "exit code 25" in for pgbackrest. My next step will be to restart the server when a current process is done, but beyond that I'm kind of stuck and have a large backlog of WAL at this point, but where do I find a reference for this error code?
>
> 2018-05-18 08:54:22.528 MDT [28589] LOG: archive command failed with
> exit code 25
> 2018-05-18 08:54:22.528 MDT [28589] DETAIL: The failed archive
> command was: pgbackrest --stanza=tsbackup archive-push
> pg_wal/000000010000A7E0000000F5
> 2018-05-18 08:54:22.529 MDT [28589] WARNING: archiving write-ahead
> log file "000000010000A7E0000000F5" failed too many times, will try
> again later

Exit code 25 is an assertion failure in pgbackrest, which should generally be very rare. Even so though, the next thing to do is enable increased logging in pgbackrest to see what's going on. Have you looked for any existing logs (eg: /var/log/pgbackrest)..? What does your pgbackrest.conf look like?

Thanks!

Stephen