On Thu, Jan 6, 2022 at 12:19 AM Bruce Momjian <br...@momjian.us> wrote: > > On Tue, Jan 4, 2022 at 10:47:47AM -0300, Fabrízio de Royes Mello wrote: > > > > > > What we did was decode the 9.6 wal files and apply transactions to the > > old 9.2 to keep it in sync with the new promoted version. This was our > > "rollback" strategy if something went wrong with the new 9.6 version. > > How did you deal with the issue that SQL isn't granular enough (vs. > row-level changes) to reproduce the result reliably, as outlined here?
This is a logical decoding plugin, so it's SQL containing decoded row-level changes. It will behave the same as a publication/suscription (apart from being far less performant, due to being plain SQL of course).
