@himbovoorhees I only see vagueposting about this, what's going on?
@himbovoorhees thanks. Postgres is such a pain in the butt
@noiob NP! Ellie (who runs our backend) spent like a whole day doing analyze and vacuuming trying to get it to sort itself out and instead ended up having to revert to a backup and incrementally update it. It was a mess.
@noiob We were genuinely hoping that it was an Us problem (as in something with our database just didn't like the new update) but then it happened to someone else... sucks.
@noiob
Basically the new Mastodon update runs a high risk of breaking an instance to the point of unusability. It happened to us a couple weeks ago, and it just happened to monads.online which is down and hopefully they can reverse it.
tl;dr the new update pulls support for PostGres 9 so if you try and import the 9 database straight to a new one, it won't actually autoconvert as it should and will instead just break.
here's Ellie's post about it specifically with advice on how to avoid it https://chat.noelle.codes/@noelle/111976788586348235