StanfordBioinformatics / pulsar_lims

A LIMS for ENCODE submitting labs.
3 stars 1 forks source link

Postgres upgrade. Urgent!!! #63

Open twang15 opened 3 years ago

twang15 commented 3 years ago

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

App: pulsar-encode

Database: postgresql-concave-14404::DATABASE_URL

You have two options:

Before 2021-Oct-11, you can 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. This dev-center article provides instructions on performing the upgrade: https://devcenter.heroku.com/articles/upgrading-heroku-postgres-databases After 2021-Oct-11, 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 2021-Nov-11. 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.

twang15 commented 3 years ago

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

App: pulsar-encode

Database: postgresql-concave-14404::DATABASE_URL

You have two options:

Before 2021-Oct-11, you can perform an upgrade to version 10 or more. Typically, you will have around 10 minutes downtime. You may want additional time to ensure that everything works properly after the upgrade. This dev-center article provides instructions on performing the upgrade: https://devcenter.heroku.com/articles/upgrading-heroku-postgres-databases

After 2021-Oct-11, we will schedule an automatic upgrade to 10. 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 2021-Nov-11. 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.

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

twang15 commented 3 years ago

Hi Annika,

This Database upgrade will be done in time.

The upgrade that I have done so far is for Heroku stack (OS, runtime, Language, Libraries and our application code), excluding Database.

The current focus is to test the reliability of the upgrade, which has already presented some challenging bugs (see in github).

Thanks, Tao

twang15 commented 2 years ago

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

App: staging-pulsar-encode

Database: postgresql-lively-14128::DATABASE_URL

You have two options:

Before 2022-Oct-10, you can perform an upgrade to version 11 or more. Typically, you will have around 10 minutes downtime. You may want additional time to ensure that everything works properly after the upgrade. This dev-center article provides instructions on performing the upgrade: https://devcenter.heroku.com/articles/upgrading-heroku-postgres-databases After 2022-Oct-10, we will schedule an automatic upgrade to 11. 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 2022-Nov-10. 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.

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