What if I told you that I need to schedule some downtime for mastodon.social to upgrade our database? :scremcat:

@Gargron you mean the version of the DB software itself I suppose? Seems reasonable.

Though I am actually kinda surprised given your size you havent moved to a master-slave configuration yet, though not sure if mastodon supports that. I think it was one of the things pleorma was trying to sell as a feature, dont quote me thoguh.

Either way, good luck!

@freemo Mastodon supports replication and I used it in the past to migrate physical machines (and upgrade disk space that way). However, Postgres 9.6 has no way of upgrading to more recent versions via replication as both ends have to use the same version.

Follow

@Gargron @freemo

What about pg_upgradecluster? I've used it since 2012 to upgrade webcookies.org Postgres database (~95 GB) through all the versions, now on 12, it's fast and reliable.

Β· Β· 0 Β· 0 Β· 1
Sign in to participate in the conversation
Mastodon πŸ” privacytools.io

Fast, secure and up-to-date instance. PrivacyTools provides knowledge and tools to protect your privacy against global mass surveillance.

Website: privacytools.io
Matrix Chat: chat.privacytools.io
Support us on OpenCollective, many contributions are tax deductible!