Re: Postgresql replication failed in Patroni

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Mendbayar Alzakhgui <mendbayar(dot)alz(at)unitel(dot)mn>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgresql replication failed in Patroni
Date: 2025-02-07 16:36:22
Message-ID: 7b2baf086987e5ab57526071b82b7c5e2be98aaa.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mendbayar Alzakhgui wrote:
> FATAL:  requested timeline 20 is not a child of this server's history
> DETAIL:  Latest checkpoint is at 71/4D8BB8C0 on timeline 19, but in the history of the requested timeline, the server forked off from that timeline at 71/4D793220.

The solution for that is usually to remove (keep a copy somewhere) the
file 00000014.history from the WAL archive. That file probably got
archived by a promoting server.

Yours,
Laurenz Albe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Motog Plus 2025-02-08 04:45:19 Seeking Advice: postgreSQL Major Version upgrade for pgpool-II and streaming replication setup
Previous Message Scott Ribe 2025-02-07 13:30:08 Re: etcd failed on master node