Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Upgrade PostgreSQL 12 to 14 and PostGIS 3.0 to 3.1 in Production #1375

Open
rachelekm opened this issue Feb 8, 2024 · 0 comments
Open

Upgrade PostgreSQL 12 to 14 and PostGIS 3.0 to 3.1 in Production #1375

rachelekm opened this issue Feb 8, 2024 · 0 comments

Comments

@rachelekm
Copy link
Collaborator

rachelekm commented Feb 8, 2024

To upgrade PostgreSQL follow instructions from last upgrade here, pending successful upgrades locally and in testing environment from production snapshot in #1374 as well as psycopg2 upgrade in #1356 . PostgreSQL 14 has community and Amazon RDS support through 2026 and we will need to upgrade PostGIS to 3.1 to support.

In the last few PostgreSQL upgrades there have been few difficulties. Similarly for PostGIS because this is a minor upgrade and the last one did not have difficulties we can expect limited issues.

NOTE: In past upgrades we estimated ~2 hours of production database downtime. Prior to beginning work we need to notify correct GoPhillyGo contact of downtime to schedule.

@rachelekm rachelekm changed the title Upgrade PostgreSQL 12 to 14 and PostGIS 3.0 to 3.1 Upgrade PostgreSQL 12 to 14 and PostGIS 3.0 to 3.1 in Production Feb 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant