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
Using synchronize_structure fails when replicating from 9.4 to 9.5 #35
Comments
Yes, I know about this issue, the only workaround I know so far is to use schema only pg_dump manually and skip the synchronize_structure. I think we should revert the change that requires pglogical_origin to be always installed since it's really only needed on 9.4 subscriber and it breaks the online upgrade scenario for 9.4 to 9.5. |
I just bumped into this very same issue while doing a POC to migrate from 9.4 to 9.5.
I assumed that was pglogical not being very clever with the requirements between versions and created the schema manually to workaround it. But still failling further ahead
I think that this last step is part of |
Or just provide an empty dummy pglogical_origin that we install on 9.5
|
@ringerc you mean something like adding a .control file with empty module_pathname?
and with a simple select on the Or is there an actual dummy implementation of such module? I could not find one... |
There isn't a dummy implementation now, but yes, that's what I'm thinking. Craig Ringer http://www.2ndQuadrant.com/ |
Empty module_pathname wouldn't do it. We'd have a different control file
we'd install for 9.5 servers that clearly said it was a dummy, and an empty
sql file to run.
|
I kinda made it work with the empty
If I let pg_restore run it it tries to execute I'm only stuck on the data sync for now. It does not error but does not get any data across.
but that is a different topic. |
should be fixed in 1.2.1 |
Hi
I'm trying to replicate from a 9.4 server to a 9.5 server.
I created the nodes on both provider & subscriber and also added all tables from the public schema to the default replication set.
When creating the subscription with:
The command fails because it tries to create the
pglogical_origin
extension in the 9.5 server (that is included in the generated dump).This extension is not available in 9.5 servers, making the
synchronize_structure
non usable when creating the subscription.Any clues or workarounds?
Thanks
The text was updated successfully, but these errors were encountered: