Yesterday I upgraded my Mastodon instance to go from PostgreSQL 15 PostgreSQL 17.
Uncategorized
5
Posts
3
Posters
10
Views
-
Yesterday I upgraded my Mastodon instance to go from PostgreSQL 15 PostgreSQL 17. The whole process was so simple that it almost seems silly to blog about it, but I did it anyway, in case anyone is interested:
https://blog.thms.uk/2025/06/upgrade-postgres-15-17-mastodon?utm_source=mastodon
Special thanks to @ruud who told me about link mode in
pg_upgradeclusterwhich was the missing piece I needed in oder to get the upgrade done with my limited disk space. -
Yesterday I upgraded my Mastodon instance to go from PostgreSQL 15 PostgreSQL 17. The whole process was so simple that it almost seems silly to blog about it, but I did it anyway, in case anyone is interested:
https://blog.thms.uk/2025/06/upgrade-postgres-15-17-mastodon?utm_source=mastodon
Special thanks to @ruud who told me about link mode in
pg_upgradeclusterwhich was the missing piece I needed in oder to get the upgrade done with my limited disk space.Tried to upgrade #postgresql for my oldfriends.live #Mastodon ( @paul ) instance from 13 to 18 and got incompatible_polymorphics errors following @michael guide. Can anyone offer advice?
The error is:
In database: postgres
aggregate: repack.array_accum(anyelement)
In database: mastodon_production
aggregate: repack.array_accum(anyelement) -
Tried to upgrade #postgresql for my oldfriends.live #Mastodon ( @paul ) instance from 13 to 18 and got incompatible_polymorphics errors following @michael guide. Can anyone offer advice?
The error is:
In database: postgres
aggregate: repack.array_accum(anyelement)
In database: mastodon_production
aggregate: repack.array_accum(anyelement)@FeedingTubePaul @paul @ruud There's a reason why my guide goes to v17 rather than v18 😬
This does sound like pg_repack is your problem though. Maybe uninstall it?
-
@FeedingTubePaul @paul @ruud There's a reason why my guide goes to v17 rather than v18 😬
This does sound like pg_repack is your problem though. Maybe uninstall it?
@michael Still failing after repack removed.
Do you think I need to
DROP AGGREGATE repack.array_accum(anyelement);for both postgres and mastodon_production databases.
If so, I need to figure out the best way to do that from the debian terminal.
I hate database upgrades.
-
@michael Still failing after repack removed.
Do you think I need to
DROP AGGREGATE repack.array_accum(anyelement);for both postgres and mastodon_production databases.
If so, I need to figure out the best way to do that from the debian terminal.
I hate database upgrades.
This post is deleted!
Gli ultimi otto messaggi ricevuti dalla Federazione
-
@upmultimedia fwiw I thought we did too and had to look it up XD
-
I would've bet a million dollars the Americans spelled torpedoes as torpedos. I honestly thought adding useless extra letters was our thinge
-
RE: https://indieweb.social/@bonfire/115718731985031138
Final 10 minutes!
-
We report late afternoon: we come out at sunset to look at distant squiggles caught in light. It is cold, and the sun goes quickly, so we are back inside within minutes. It is really good; our cheeks burn, our nose runs, and we are still smiling when we meet eyes in the mirror.
-
@n_margiotta le linee gialle sono pericolosissime, è giusto sparare, ammazzare, uccidere, chiunque si avvicini a una linea gialla
-
@valhalla ciò che stiamo provando a creare con citiverse.it (su #NodeBB) è proprio questo: ospitare, ma SOPRATTUTTO censire realtà locali, attraverso gruppi locali e localizzati che possono essere "visti" dal Fediverso. Ma chi visita il forum può vedere le associazioni sia sotto la categoria regionale, sia sotto quella tematica (vedi immagine con il caso @fiab-l-aquila di @filippocatania)
PS: a proposito, c'è anche la categoria @como, quindi se la vuoi usare... 😅
-
@snow allora è federato, ma non ricordo di averlo fatto... @fediverso @addio-big-tech
-
@brohrer ANY two numbers?
