MozillaFoundation / mofo-devops

Mozilla Foundation DevOps Plans, Issues, Discussions
12 stars 5 forks source link

Align heroku database versions #811

Closed Pomax closed 3 years ago

Pomax commented 3 years ago

We're currently using four different postgresql versions:

Let's get these all on the same version, or we're going to be chasing database ghosts, where one system's failing while everything else shows no indication of failure.

tomusher commented 3 years ago

As a first step for this I've added a new Postgres 12.5 addon to foundation-mofostaging-net and donate-wagtail-staging, copied across the data and made them the primary database. The old versions remain in case we need to rollback.

@pomax could you check staging on these sites to make sure everything works as you expect?

Pomax commented 3 years ago

very nice, as far as I can tell this is working the same as before.

tomusher commented 3 years ago

I've removed the old 9.6 staging databases and done the same upgrades to the two production sites, leaving the old databases in place for now.