Cluster restore scenarios
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Hi.
I did not find information in the documentation about scenarios for restoring a cluster from a backup.
I consider 2 main scenarios for the case of restoring from a backup.
1. A logical data corruption that would require a full restore of all nodes to point in time (PITR) from a physical copy (for example pgbackrest)
Steps:
- stop coordinator, workers.
- restore data on all nodes at one point in time.
Are there any changes to the metadata on the coordinator?
2. Loss of one of the workers.
Steps:
- stop the cluster
- create a new worker
- restore data from a physical backup to the last available point in time from a backup of a lost worker.
Are there any changes to the metadata on the coordinator?
Are my steps correct?
Is it possible that the data on the workers after restoring from a backup will not be consistent with the metadata on the coordinator (for example, shardminvalue / shardmaxvalue or others)?
Maybe some other advice?
Thank you
Contributor guide
Assessment
This issue has not been assessed yet.