Re: On Replica - History issue

On Mon, 2023-10-30 at 13:48 +0300, SOzcn wrote:
> > > Oct 27 13:33:26 se-prd-db02 postgresql(at)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(at)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