News for hackers. Stuff that matters.
Re:Leaving MySQL by PikachuEXE on Monday December 06, 2021 @01:44AM (#29456920)
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)

Re:Leaving MySQL by rtpg on Monday December 06, 2021 @03:08AM (#29457367)
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?
Re:Leaving MySQL by virgilp on Monday December 06, 2021 @02:57AM (#29457306)
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.