Yesterday I upgraded my Mastodon instance to go from PostgreSQL 15 PostgreSQL 17.

[michael@mstdn.thms.uk]

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_upgradecluster which was the missing piece I needed in oder to get the upgrade done with my limited disk space.

#mastoadmin #postgres #postgreSQL

[feedingtubepaul@masto.ai]

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)

@ruud #MastoAdmin

[michael@mstdn.thms.uk]

@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@masto.ai]

@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.

@ClearlyClaire

[luca@sironi.xyz]

This post is deleted!