Closed Bug 1578537 Opened 1 year ago Closed 3 months ago

Upgrade PostgreSQL by 13 Nov 2019

Categories

(Webtools :: Pontoon, task, P1)

task

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: mathjazz, Assigned: mathjazz)

Details

From an email from Heroku:


PostgreSQL 9.4 reaches End of Life on 2020-Feb-13. Due to security and operational concerns, Heroku cannot run unsupported software as a service. Therefore, the following database will need to be updated before 2020-Feb-13:

App: mozilla-pontoon

Database: rolling-carefully-5193::HEROKU_POSTGRESQL_GREEN_URL

You have two options:

Before 2019-Nov-13, you can schedule a time to perform an upgrade to version 9.6 or more. Typically, you will have around 10 minutes downtime. You may want additional time to ensure that everything works properly after the upgrade.

After 2019-Nov-13, we will schedule an automatic upgrade to 9.6. This forced upgrade will incur significant downtime for the database and associated app(s), which can reach 12 hours in extreme cases.

All upgrades must be completed by 2020-Feb-13. We reserve the right to deprovision any database not upgraded at that time.

We recognize that deprecations and upgrades impact your productivity and customer experience. We think it’s worth the effort to run on secure and supported software. Please email data@heroku.com with questions or concerns.

Best regards,

The Heroku Data Team

Upgrade instructions and version support:

https://devcenter.heroku.com/articles/upgrading-heroku-postgres-databases.

https://devcenter.heroku.com/articles/heroku-postgresql#version-support

I might be a bit paranoid, but I'm not sure we should have this bug public, with details of the software used for Pontoon in prod.

Group: mozilla-employee-confidential

What do we need to actually do here? Do we expect to have to do any code changes? Updating psycopg2 per https://docs.djangoproject.com/en/1.11/ref/databases/#postgresql-notes ?

I see that we have the following versions we could upgrade to?

  • 11 (default)
  • 10
  • 9.6

I also see that we're testing against 9.4 on travis, but docker-compose doesn't specify a pg version at all? What do folks actually test against locally?

Which should we pick?

We need to pick the upgrade method and execute it:
https://devcenter.heroku.com/articles/upgrading-heroku-postgres-databases

IIRC we used pg:copy the last time.

We should test with staging first.

I don't know which version to upgrade to.

I'm expecting to have more time to look into this the week after the next week.

I'll try to bump stage to version 11 and see how it goes.

Assignee: nobody → m
Status: NEW → ASSIGNED

Stage worked fine so I went ahead and upgraded Prod, too.

Status: ASSIGNED → RESOLVED
Closed: 3 months ago
Resolution: --- → FIXED
Group: mozilla-employee-confidential
You need to log in before you can comment on or make changes to this bug.