Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Phase 2][Colocation] Handle colocated tables in YSQL distributed backup/restore #4517

Closed
ndeodhar opened this issue May 19, 2020 · 1 comment
Closed

[Phase 2][Colocation] Handle colocated tables in YSQL distributed backup/restore #4517

ndeodhar opened this issue May 19, 2020 · 1 comment
Assignees
@OlegLoginov @yifanguan
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
Colocation

Comments

@ndeodhar
Copy link
Contributor

ndeodhar commented May 19, 2020 •
edited by jira bot

Jira Link: [DB-396](https://yugabyte.atlassian.net/browse/DB-396)
Backup script should:

  1. Include colocated/not colocated in metadata
  2. Generate CREATE TABLE statements that include PG table OID.

Restore should:

  1. Use PG table OID while creating the table.
  2. Create colocated tables before creating non-colocated tables to avoid OID clashes.
@ndeodhar ndeodhar added the area/ysql Yugabyte SQL (YSQL) label May 19, 2020
@rkarthik007 rkarthik007 mentioned this issue Jul 28, 2020
Closed
@tverona1 tverona1 mentioned this issue Apr 27, 2022
Open
@tverona1 tverona1 added this to To do in Colocation via automation May 13, 2022
@tverona1 tverona1 changed the title [Colocation] Handle colocated tables in YSQL distributed backup/restore [Phase2][Colocation] Handle colocated tables in YSQL distributed backup/restore May 17, 2022
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels May 17, 2022
@tverona1 tverona1 changed the title [Phase2][Colocation] Handle colocated tables in YSQL distributed backup/restore [Phase 2][Colocation] Handle colocated tables in YSQL distributed backup/restore May 17, 2022
@yugabyte-ci yugabyte-ci changed the title [Phase 2][Colocation] Handle colocated tables in YSQL distributed backup/restore [Phase 2][Colocation] Handle colocated tables in YSQL distributed backup/restore1 Jun 2, 2022
@yugabyte-ci yugabyte-ci changed the title [Phase 2][Colocation] Handle colocated tables in YSQL distributed backup/restore1 [Phase 2][Colocation] Handle colocated tables in YSQL distributed backup/restore Jun 2, 2022
@yugabyte-ci yugabyte-ci assigned yifanguan and unassigned frozenspider Aug 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/bug This issue is a bug labels Aug 23, 2022
@yifanguan
Copy link
Contributor

yifanguan commented Nov 18, 2022 •
edited

Close this issue because instead of using table OID, we introduced colocation ID to solve the backup of colocated tables. See commit 71d527c for details.

Colocation automation moved this from To do to Done Nov 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@OlegLoginov OlegLoginov

@yifanguan yifanguan

Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature priority/medium Medium priority issue
Projects
Colocation
Done
YQL-beta
Status: Done
Milestone
No milestone
Development

No branches or pull requests
5 participants
@frozenspider @ndeodhar @yugabyte-ci @OlegLoginov @yifanguan