Message-ID: <6df759efadaf406cf72ee4440204b25aa4ca407f.camel@cybertec.at>
Subject: Re: BUG #18179: Cluster History Error
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Abdullah Ergin <abdullaherginwork@gmail.com>, Michael Paquier
	 <michael@paquier.xyz>
Cc: pgsql-bugs@lists.postgresql.org
Date: Mon, 13 Nov 2023 20:05:19 +0100
In-Reply-To: 
 <CAJZxWEPQ6FixVPsChpxzKt5Lr+nzqzL-vOrZXdGCX+LptvPZwg@mail.gmail.com>
References: <18179-c25cb10fdc41bbf5@postgresql.org>
	 <ZUhxh2UfISvGO-Oq@paquier.xyz>
	 <CAJZxWEPQ6FixVPsChpxzKt5Lr+nzqzL-vOrZXdGCX+LptvPZwg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/6df759efadaf406cf72ee4440204b25aa4ca407f.camel%40cybertec.at>
Precedence: bulk

On Mon, 2023-11-13 at 21:00 +0300, Abdullah Ergin wrote:
> =C2=A0Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: sh: 1: pgba=
ckrest: not found
> =C2=A0Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 =
17:01:44.700 +03 [767228] FATAL: could not restore file "00000004.history" =
from archive: command not found
> =C2=A0Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 =
17:01:44.703 +03 [767227] LOG: startup process (PID 767228) exited with exi=
t code 1
> =C2=A0Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 =
17:01:44.703 +03 [767227] LOG: aborting startup due to startup process fail=
ure
> =C2=A0Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: 2023-11-09 =
17:01:44.745 +03 [767227] LOG: database system is shut down
>=20
> Based on this, I checked the `postgresql.auto.conf` on my master server, =
and the restore information found there is as follows:
>=20
> # Recovery settings generated by pgBackRest restore on 2021-09-29 01:04:4=
0
> restore_command =3D 'pgbackrest --stanza=3Dmydb_stanza archive-get %f "%p=
'

Use the absolute path for "pgbackrest".
Did you install pgBackRest on the standby?

Yours,
Laurenz Albe