Gregory's Server
@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.
|
No comments
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. |
@Gargron ahh, lame. and kinda surprising, postgres has a better reputation than that. Though to be fair I dont use postgres as a developer as much as I used to in a way where I need to maintain my own instance. I've been using amazon AWS's postgres for a while now in most professional settings and that is always seemless somehow on upgrades.