Hello All I have promoted secondary server. If I want old

Question

Hello All I have promoted secondary server. If I want old

master back in line and then my promoted server as slave what I have to do. I tried pg_rewind it's not working. Is there any procedure?

#programming #russian

0

25.08.2024

3 ответов

10 просмотров

N@R£N Автор вопроса

Stefanie Janine Stölting
It is probably on the wrong timeline. You'd need ...

Ok, how can we perform manual failover and failback?

0

4 месяца назад

Stefanie Janine Stölting

N@R£N
Ok, how can we perform manual failover and failbac...

Promote the follower with SELECT pg_promote(); Or run pg_ctl promote Create a standby.signal file on the current primary and restart it an run pg_rewind. You'd need to adjust your backup tool as the WAL files from a promoted secondary aren't and can't be used for ongoing point in time backups. Or learn and use at least repmgr when you can't use Patroni.

0

4 месяца назад

Stefanie Janine Stölting · Accepted Answer

Stefanie Janine Stölting

It is probably on the wrong timeline. You'd need to start it as a new follower.

0

4 месяца назад

169 похожих чатов

Hello All I have promoted secondary server. If I want old

3 ответов

Похожие вопросы