From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Abdullah Ergin <abdullaherginwork@gmail.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18179: Cluster History Error
Date: Mon, 13 Nov 2023 20:05:19 +0100
Message-ID: <6df759efadaf406cf72ee4440204b25aa4ca407f.camel@cybertec.at> (raw)
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>
On Mon, 2023-11-13 at 21:00 +0300, Abdullah Ergin wrote:
> Nov 09 17:01:44 se-prd-db02 postgresql@13-mydb[767207]: sh: 1: pgbackrest: not found
> Nov 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
> Nov 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 exit code 1
> Nov 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 failure
> Nov 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
>
> Based on this, I checked the `postgresql.auto.conf` on my master server, and the restore information found there is as follows:
>
> # Recovery settings generated by pgBackRest restore on 2021-09-29 01:04:40
> restore_command = 'pgbackrest --stanza=mydb_stanza archive-get %f "%p'
Use the absolute path for "pgbackrest".
Did you install pgBackRest on the standby?
Yours,
Laurenz Albe
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: laurenz.albe@cybertec.at, abdullaherginwork@gmail.com, michael@paquier.xyz, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18179: Cluster History Error
In-Reply-To: <6df759efadaf406cf72ee4440204b25aa4ca407f.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox