I need to migrate a couple of servers running postgresql 9.4 been syncro with streaming replication to postgresql 9.6. Obviously the service could not be stopped.
Does any of you test to syncro data via streaming replication from a source in 9.4 and a target in 9.6?
Do you have a "howto" tested?
You can't. Streaming replication requires you use the same major version on all the nodes.