[YSQL] Backups: Add --ignore_existing_tablespaces flag #20334
Assignees
Labels
area/ysql
Yugabyte SQL (YSQL)
kind/enhancement
This is an enhancement of an existing feature
priority/medium
Medium priority issue
Comments
yugabyte-ci
added
kind/enhancement
1 task
OlegLoginov
added a commit
that referenced
this issue
Dec 22, 2023
Summary: Changes: 1. The new flag `--ignore_existing_tablespaces` is added into `yb_backup.py` script. 2. `ysql_dumpall` tool is changed to dump Tablespaces with `if (ignore_existing_tablespaces)` statement. The changes allow ignoring errors like `tablespace "region1_ts1" already exists` when the backup-restore recreates the YSQL Tablespaces. NOTE: "STOP_ON_ERROR" should be enabled to see the effect. (set variable `ENABLE_STOP_ON_YSQL_DUMP_RESTORE_ERROR` into `True` in the `yb_backup.py`. Now it's `False`.) Jira: DB-9319 Test Plan: Set `ENABLE_STOP_ON_YSQL_DUMP_RESTORE_ERROR=True` in `yb_backup.py`. New tests: ybd --java-test org.yb.pgsql.TestYbBackup#testFailureOnExistingTablespaces ybd --java-test org.yb.pgsql.TestYbBackup#testIgnoreExistingTablespaces ybd --java-test org.yb.pgsql.TestYsqlDump#ysqlDumpAllWithoutYbMetadata Other related tests ybd --java-test org.yb.pgsql.TestYsqlDump#ysqlDumpAllWithYbMetadata ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioning ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioningNoRegions ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioningOneRegion ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioningRestoringIntoExisting ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioningWithTablespaces ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioningNoRegionsWithTablespaces ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioningOneRegionWithTablespaces ybd --java-test org.yb.pgsql.TestYbBackup#testGeoPartitioningRestoringIntoExistingWithTablespaces Reviewers: mihnea, tverona, yguan Reviewed By: yguan Subscribers: yugaware, yql Differential Revision: https://phorge.dev.yugabyte.com/D30956
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Jira Link: DB-9319
Description
Top level GHI: #20333
The new flag allows to ignore existing TABLESPACEs during the YSQL DB backup-restore.
Affected components:
ysql_dumpallbinary tool,yb_backup.pyscript.Issue Type
kind/enhancement
Warning: Please confirm that this issue does not contain any sensitive information
The text was updated successfully, but these errors were encountered: