News for hackers. Stuff that matters.
Re:Leaving MySQL by rtpg on Monday December 06, 2021 @01:16AM (#29456752)
We had tried to do a logical replication-based strategy for Postgres to achieve no-downtime version upgrades during business hours, but there were so many gotchas and things you have to do on the side (stuff like sequence tracking etc), that we just gave up and took the downtime to do it more safely.

I think Postgres is really cool and has a lot of good reliability, but I've always wondered what people do for high availability. And yeah, pgbouncer being a thing bugs,

It feels like we're getting closer and closer to "vanilla pg works perfectly for the common worklfows" though, so tough to complain too much.

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.