4 ms·
I have written an article about upgrading PSQL with no/low downtime with Logical Replication. (More like a note to my future self) See if you can understand en
by PikachuEXE 5y ago
I have written an article about upgrading PSQL with no/low downtime with Logical Replication. (More like a note to my future self)
See if you can understand enough of it and consider doing it again for next upgrade. (I have done that for 12 > 13)
- nikisweeting 5y agoWhats the link?
- virgilp 5y agoI suppose https://dev.to/pikachuexe/postgresql-logical-replication-for-upgrade-41hl https://dev.to/pikachuexe/postgresql-logical-replication-for... would be it.
- PikachuEXE 5y agoThis is what happen I don't have enough sleep... I forgot to post the article link! Thanks for posting it.
- psychoslave 5y agoMaybe you could give a link to the post
- rtpg 5y agoSo 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