Re: On Replica - History issue

Поиск
Список
Период
Сортировка
От SOzcn
Тема Re: On Replica - History issue
Дата
Msg-id CAJyV5AYh76Co_mvarejrczihyFgwTPKiCdVo50Kv886bXdAkiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: On Replica - History issue  (SOzcn <selahattinozcnma@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: SOzcn
Дата:
Сообщение: Re: On Replica - History issue
Следующее
От: Siraj G
Дата:
Сообщение: AUTOVACUUM