Re: Resetting recovery target parameters in pg_createsubscriber

On Thu, Nov 13, 2025 at 7:46 AM Alena Vinter <dlaaren8@gmail.com> wrote:
> Robert, here's a realistic scenario where the issue occurs:
> 1. Start with a primary and physical standby
> 2. Convert the standby to a logical replica using `pg_createsubscriber`
> 3. Later, create a new physical standby from a backup of this logical replica
> 4. The new standby fails to start because it cannot reach consistency point
>
> The root cause is that `pg_createsubscriber` leaves behind recovery parameters that interfere with the new standby's
startupprocess, causing recovery to stop before reaching a consistency point. 

Yes, I agree this is a much better scenario to test. Thanks.

--
Robert Haas
EDB: http://www.enterprisedb.com