[docdb] Add rail guards to prevent restore if shared relations are modified #9503
Labels
area/docdb
YugabyteDB core features
kind/enhancement
This is an enhancement of an existing feature
priority/medium
Medium priority issue
Jira Link: DB-2082
For PITR support for YSQL, we support snapshots and recovery per database (to take care of indexes, related foreign key constraints, etc). However, Postgres has several shared tables that are not maintained at a per-database level but instead, there's one common relation shared by all the tables. For example, tablespaces and roles fall under this purview. If such tables are modified and we want to restore a database such that these need to be changed then we aren't sure if we want to support it or not. For starters, it can have side effects that affect other databases that aren't being tracked by PITR. At the very least we should add rail guards to error out if the user wants to restore in such scenarios. cc @spolitov @bmatican
The text was updated successfully, but these errors were encountered: