So to be honest I see that article (linked below) and I think "Yeah that's probably all right", but given this is for a Real Sytem With Serious People's Data, when faced with "take the downtime and do the offline data upgrade that _basically everyone does_" and "try to use logical replication to get a new database in the right state, knowing that logical replication doesn't copy _everything_ so I need to manually copy some stuff, and if I miss stuff I'm in a bad situation"...
I trust the pg people that tools do what are advertised, but it's a very high risk proposition
Re:Leaving MySQL
by psychoslave on Monday December 06, 2021 @02:32AM
(#29457168)
Maybe you could give a link to the post
Re:Leaving MySQL
by nikisweeting on Monday December 06, 2021 @02:31AM
(#29457162)
Whats the link?
I suppose https://dev.to/pikachuexe/postgresql-logical-replication-for... would be it.
Re:Leaving MySQL
by PikachuEXE on Monday December 06, 2021 @09:22PM
(#29468480)
This is what happen I don't have enough sleep...
I forgot to post the article link!
Thanks for posting it.
See if you can understand enough of it and consider doing it again for next upgrade. (I have done that for 12 > 13)