Postgres Pro
Downloads
Home   >   mailing lists

Re: Unable to start replica after failover - Mailing list pgsql-general

From Alexander Kukushkin
Subject Re: Unable to start replica after failover
Date
Msg-id CAFh8B=mPc_a_W4c7PjF4+E4E5Prb9=gq1FjAEHozvxVbMb=d-Q@mail.gmail.com
Whole thread Raw
In response to RE: Unable to start replica after failover  ("Lahnov, Igor" <Igor.Lahnov@nexign.com>)
Responses RE: Unable to start replica after failover  ("Lahnov, Igor" <Igor.Lahnov@nexign.com>)
List pgsql-general
Tree view
Hi Igor,


On Fri, 26 Aug 2022 at 13:43, Lahnov, Igor <Igor.Lahnov@nexign.com> wrote:

I can't answer your question. What do you think, the recovery from the archive should work in this case?

1. the partial file should not be restored at all cases

2. the partial file should recover as a partial and replace the local partial

3. recovery command, should return a conflict - file already exists


The partial file should never be restored automatically.
I have no clue why pg_probackup developers decided to do it.
Postgres never requests the partial file using the restore_command, instead, it requests a file from the next timeline.

Regards,
--
Alexander Kukushkin

pgsql-general by date:

Previous
From: Meera Nair
Date:
Subject: RE: Unable to archive logs in standby server
Next
From: Matheus Martin
Date:
Subject: Missing query plan for auto_explain.