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

From SOzcn
Subject Re: On Replica - History issue
Date
Msg-id CAJyV5AYh76Co_mvarejrczihyFgwTPKiCdVo50Kv886bXdAkiQ@mail.gmail.com
Whole thread Raw
In response to Re: On Replica - History issue  (SOzcn <selahattinozcnma@gmail.com>)
List pgsql-admin
I also checked my prod cluster wal file, there has no that file either. I missing something I don't see.

SOzcn <selahattinozcnma@gmail.com>, 30 Eki 2023 Pzt, 13:48 tarihinde şunu yazdı:
Hello, 

"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?

Laurenz Albe <laurenz.albe@cybertec.at>, 27 Eki 2023 Cum, 15:30 tarihinde şunu yazdı:
On Fri, 2023-10-27 at 13:36 +0300, SOzcn wrote:
> Hello I need some advice about the issue in the bellow. Because of datacenter I has
> to create my replica's from zero. On a cluster I get a error, it's look like about
> pgbackrest issue, but also this one has no backup for now. Before it has. Is there
> anything I should do Manuel?
>
> Oct 27 13:33:26 se-prd-db02 postgresql@13-clustername[316944]: sh: 1: pgbackrest: not found
> 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

I don't think Manuel is at fault.

You should use the absolute path to "pgbackrest" in the "restore_command".

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: SOzcn
Date:
Subject: Re: On Replica - History issue
Next
From: Siraj G
Date:
Subject: AUTOVACUUM