From: Laurenz Albe <laurenz.albe@cybertec.at>
To: SOzcn <selahattinozcnma@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: On Replica - History issue
Date: Mon, 30 Oct 2023 13:29:52 +0100
Message-ID: <164cc3ba568cc350de5a7367df94972533ca2935.camel@cybertec.at> (raw)
In-Reply-To: <CAJyV5AaJh1Jvsz4yGhTu9gAVZD09awr_SZqxvVqzbpV5L_mKWQ@mail.gmail.com>
References: <CAJyV5AbGPAyqnpHcBkuENdmbm=+7S0Gh4rkj0ZmYTBB2-vjkmg@mail.gmail.com>
<fc13c6aa5c7ed403cae375ec437d80d5ed86c619.camel@cybertec.at>
<CAJyV5AaJh1Jvsz4yGhTu9gAVZD09awr_SZqxvVqzbpV5L_mKWQ@mail.gmail.com>
On Mon, 2023-10-30 at 13:48 +0300, SOzcn wrote:
> > > Oct 27 13:33:26 se-prd-db02 postgresql@13-clustername[316944]: 2023-10-27 13:33:26.808 +03 [316957] FATAL: could not restore file "00000003.history" from archive: command not found
> > > Oct 27 13:33:26 se-prd-db02 postgresql@13-clustername[316944]: sh: 1: pgbackrest: not found
> >
> > You should use the absolute path to "pgbackrest" in the "restore_command".
>
> "restore_command" is default .
> my archive command is ;
> archive_command = 'pgbackrest --stanza=cluster_stanza archive-push %p'
>
> with this way I setup my backup procedure without problem, is there might be another problem I cannot see?
You get a fatal error restoring a file from the archive, because the restore command is not found.
What is unclear about the error message? Why don't you try the absolute path?
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-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, selahattinozcnma@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: On Replica - History issue
In-Reply-To: <164cc3ba568cc350de5a7367df94972533ca2935.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