Thread: timeline problem when recovery

From

Fabrice Chapuis

Date:

10 December, 20:01:15

Hi, I got this message on a standby after a FO of PG14 cluster with 3 nodes.

user=,db=,client=,application= LOG: new timeline 20 forked off current database system timeline 19 before current recovery point CC8/164E9350

this message come from xlog.c rescanLatestTimeLine function:

if (currentTle->end < EndRecPtr)

{

ereport(LOG,

(errmsg("new timeline %u forked off current database system timeline %u before current recovery point %X/%X",

newtarget,

ThisTimeLineID,

LSN_FORMAT_ARGS(EndRecPtr))));

return false;

}

To complete recovery of standby, rewind was used to come back to the fork.

Is that means that standby by was before hand compare to the new primary (new TL) and potentially loosing data on this primary.

Regards,

Fabrice