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

From SOzcn
Subject Re: On Replica - History issue
Date
Msg-id CAJyV5AYc-PPSDrYhsLca3amajTfNuVMgOTKc93Zd9_Tq-QvzsA@mail.gmail.com
Whole thread Raw
In response to Re: On Replica - History issue  (SOzcn <selahattinozcnma@gmail.com>)
List pgsql-admin
Can you give me more details please? I've been created more than 20 cluster replica without problem, on a cluster I get this and unfortunately I can't figure it out like as I say on top. 

SOzcn <selahattinozcnma@gmail.com>, 30 Eki 2023 Pzt, 16:27 tarihinde şunu yazdı:
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: Loles
Date:
Subject: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')
Next
From: HALAT-PRUVOT SYLVIE
Date:
Subject: RE: Optimized WHERE UPPER(name) LIKE UPPER('%p_name%')