8000 Support skipping extensions & filtering in pgcopydb dump/restore cli by arajkumar · Pull Request #572 · dimitri/pgcopydb · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Support skipping extensions & filtering in pgcopydb dump/restore cli #572 8000

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.

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

Merged
merged 1 commit into from
Dec 19, 2023

Conversation

arajkumar
Copy link
Contributor
@arajkumar arajkumar commented Dec 11, 2023

Currently, pgcopydb dump & restore doesn't support skipping extensions or filtering because we don't populate the context with extension details & skip list information.

@arajkumar arajkumar force-pushed the extension-skip-cli-restore branch 2 times, most recently from 13d80b3 to 5b34c96 Compare December 11, 2023 12:56
@arajkumar arajkumar changed the title Support skipping extensions & filtering in pgcopydb restore Support skipping extensions & filtering in pgcopydb dump/restore Dec 11, 2023
@arajkumar arajkumar changed the title Support skipping extensions & filtering in pgcopydb dump/restore Support skipping extensions & filtering in pgcopydb dump/restore cli Dec 11, 2023
@dimitri
Copy link
Owner
dimitri commented Dec 15, 2023

Please rebase to the current main branch, now that the SQLite catalogs are merged you will see some impact in how to handle this. It might be that we don't need this PR anymore, but I'm not sure. The main difference is that we have an on-disk cache of the catalogs now.

@arajkumar
Copy link
Contributor Author

@dimitri It looks we still needthis, it enables --skip-extensions cli flag to dump & restore. Additionally I see quite a few issues while testing pgcopydb dump, pgcopydb restore cli programs. One of them is #585.

@@ -370,7 +380,7 @@ cli_dump_schema_section(CopyDBOptions *dumpDBoptions,
exit(EXIT_CODE_INTERNAL_ERROR);
}

if (!copydb_init_specs(&copySpecs, dumpDBoptions, DATA_SECTION_NONE))
if (!copydb_init_specs(&copySpecs, dumpDBoptions, DATA_SECTION_ALL))
Copy link
Owner

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I'm not sure that we need DATA_SECTION_ALL here, but thinking about it, we might. After all we want to be able to implement the whole filtering.

dimitri
dimitri previously approved these changes Dec 18, 2023
Currently, pgcopydb dump & restore doesn't support skipping extensions or filtering because we don't populate the context with extension details & skip list information.

Signed-off-by: Arunprasad Rajkumar <ar.arunprasad@gmail.com>
@arajkumar
Copy link
Contributor Author

@dimitri I found few more issues which are independent of this work. I created a separate PR to fix them: #587

@arajkumar arajkumar force-pushed the extension-skip-cli-restore branch from fb38825 to de1423f Compare December 19, 2023 11:33
@dimitri dimitri merged commit ce0696f into dimitri:main Dec 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants
0