parallel PITR for HA setup
От
magodo
Тема
parallel PITR for HA setup
Дата
Msg-id
aab38d6dd85929a9ab2b15132431e8b538599b42.camel@sina.com
Список
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
Дата: