parallel PITR for HA setup

Поиск
Список
Период
Сортировка
От magodo
Тема parallel PITR for HA setup
Дата
Msg-id aab38d6dd85929a9ab2b15132431e8b538599b42.camel@sina.com
обсуждение исходный текст
Список pgsql-general
Hello,

I have a HA setup, a standby following a primary.

At beginning, when I do PITR for it, I just recover the primary the
first, then remake the standby by doing a basebackup against primary
and restart the standby with recovery.conf properly.

This works well, however, it takes long time when I have tons of data
to recover. Then I starts to find out how to do parallel PITR for both
clusters and re-establish the relationship between them. Then I find an
issue, after recovery for both clusters, they are at same LSN. Then on
the standby, I need to create a recovery.conf file, and restart it,
which will end up with standby's LSN newer than the current flushed one
on primary.

My solution to this problem is to do a restart also on primary. I
wonder if this is a proper way.

Thank you in advance!
---
Magodo




В списке pgsql-general по дате отправления:

Предыдущее
От: Abhishek Tripathi
Дата:
Сообщение: Fwd: Want to acquire lock on tables where primary of one table isforeign key on othere
Следующее
От: Mike Martin
Дата:
Сообщение: Advice on logging strategy