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

Update PostgreSQL to newer version #4739

Open
StevenMaude opened this issue Nov 13, 2024 · 0 comments
Open

Update PostgreSQL to newer version #4739

StevenMaude opened this issue Nov 13, 2024 · 0 comments

Comments

@StevenMaude
Copy link
Contributor

The PostgreSQL version in use is apparently 13, judging from the Docker configuration, as introduced here back in 2021.

It's not been updated to a new major version since, as far as I can tell, although I can't check what Digital Ocean is actually running.

The end of life for PostgreSQL 13 is a year today — 2025-12-23 — so we should update before then.

This will require work along the lines of:

  • some local testing to see if there any issues with upgrading the database
  • fixing any issues if there are
  • upgrading the PostgreSQL version in docker-compose.yml
  • backing up the database immediately prior to upgrade (this may happen automatically on upgrade)
  • upgrading the database via Digital Ocean, which apparently can happen with no downtime
  • confirming the upgrade has succeeded
  • developers working on job-server upgrading their local setups, if they're not using Docker to run the database

One potential issue depending on how access to the current database is controlled; for password authentication, newer versions of PostgreSQL enforce a newer password authentication scheme than older versions. It may be that any such database credentials need reconfiguring before or after the PostgreSQL upgrade.

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