Re: On Replica - History issue - Mailing list pgsql-admin

From SOzcn
Subject Re: On Replica - History issue
Date
Msg-id CAJyV5AZa4bmb68JRctyPnS9u8cK-Eib3r24cgLYwKUC2Yb7NRQ@mail.gmail.com
Whole thread Raw
In response to Re: On Replica - History issue  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: On Replica - History issue
List pgsql-admin
I do with absolute path already, that's the problem. 


Laurenz Albe <laurenz.albe@cybertec.at>, 30 Eki 2023 Pzt, 15:29 tarihinde şunu yazdı:
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

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: On Replica - History issue
Next
From: Loles
Date:
Subject: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')