Обсуждение: pg_basebackup and timeline issues

Поиск
Список
Период
Сортировка

pg_basebackup and timeline issues

От
Clécio Anderson
Дата:
Hi!

Sometimes when I need to run pg_basebackup to recreate a slave server I receive the error message below:

Latest checkpoint is at 427A/6D6743F0 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at 0/0

When it happens.. After I edit master's history file pointing to a timeline referenced by the slave's slot I can issue the pg_basebackup without hassle.

I would like to know If there is any way to ignore or bypass this timeline lookup on master`s history file when issuing pg_basebackup command on slave server.

Thanks!!

--
Regards,

Clécio Anderson de Lima Ferreira

Re: pg_basebackup and timeline issues

От
Laurenz Albe
Дата:
On Tue, 2020-05-19 at 15:02 -0300, Clécio Anderson wrote:
> Sometimes when I need to run pg_basebackup to recreate a slave server I receive the error message below:
> Latest checkpoint is at 427A/6D6743F0 on timeline 2, but in the history of the requested timeline, the server forked
offfrom that timeline at 0/0
 
> When it happens.. After I edit master's history file pointing to a timeline referenced by the slave's slot I can
issuethe pg_basebackup without hassle.
 
> I would like to know If there is any way to ignore or bypass this timeline lookup on master`s history file when
issuingpg_basebackup command on slave server.
 

Not sure, but did you remove any *.history files in the WAL directory?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




Re: pg_basebackup and timeline issues

От
Clécio Anderson
Дата:
Yes.. It happened twice... I had a script cleaning some old files..
I needed to recreate the history file sometimes to be able to issue pg_basebackup command on slave without errors.

Em qua., 20 de mai. de 2020 às 04:59, Laurenz Albe <laurenz.albe@cybertec.at> escreveu:
On Tue, 2020-05-19 at 15:02 -0300, Clécio Anderson wrote:
> Sometimes when I need to run pg_basebackup to recreate a slave server I receive the error message below:
> Latest checkpoint is at 427A/6D6743F0 on timeline 2, but in the history of the requested timeline, the server forked off from that timeline at 0/0
> When it happens.. After I edit master's history file pointing to a timeline referenced by the slave's slot I can issue the pg_basebackup without hassle.
> I would like to know If there is any way to ignore or bypass this timeline lookup on master`s history file when issuing pg_basebackup command on slave server.

Not sure, but did you remove any *.history files in the WAL directory?

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com



--
Atenciosamente,

Clécio Anderson de Lima Ferreira