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.

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

how is data changes handled during initial data synchronization? #52

Closed
carolfly86 opened this issue Oct 28, 2016 · 1 comment
Closed
Labels

Comments

@carolfly86
Copy link

carolfly86 commented Oct 28, 2016

We aim to do online upgrade from 9.4 to 9.5 with pglogical. Our tables are quite large (37GB), and take over 1hr to synchronize with SELECT pglogical.replication_set_add_all_tables('default', ARRAY['public'], true);

Will the data changes made during the synchronize process be missing from subscriber? If it is, is there a way to ensure those changes are carried over to subscriber?

@ringerc
Copy link
Contributor

ringerc commented Oct 28, 2016

It's handled automatically by the snapshot exported during replication slot creation, so long as you get pglogical to handle schema and data sync.

Please don't use this bug tracker for general questions. Use the pglogical/bdr mailing list/forum at pglogical-list@2ndquadrant.com / https://groups.google.com/a/2ndquadrant.com/forum/#!forum/bdr-list . This github tracker is for bug reports and feature requests only.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants