Skip to content

Upgrade publishing-api database to Postgres 17 #3358

@nicholsj

Description

@nicholsj

These are not intended as a complete set of all tasks - those are in the runbooks (linked below). Instead these are the key stages that it's useful to track

  • Make a copy of the dev runbook and update with relevant changes

Integration

Developer runbook for staging & integration - updated version of the runbook for publishing-api specifically in integration and staging
SRE runbook for publishing-api staging & integration - updated version of the runbook for publishing-api specifically in integration & staging

  • [SRE] set up parameter group
  • [Dev] Perform blue/green deployment and switchover
  • [Dev] Clean up tasks
  • [SRE] Terraform state manipulation
  • [SRE] Update sheet

Staging

Developer runbook for staging & integration - updated version of the runbook for publishing-api specifically in integration and staging
SRE runbook for publishing-api staging & integration - updated version of the runbook for publishing-api specifically in integration & staging

  • [SRE] set up parameter group
  • [Dev] Perform blue/green deployment and switchover
  • [Dev] Clean up tasks
  • [SRE] Terraform state manipulation
  • [SRE] Update sheet

Production

SRE runbook for publishing-api production - updated version of the runbook for publishing-api specifically in production
Developer runbook for production - updated version of the runbook for publishing-api specifically in production
[Developer runbook for staging & integration]

  • [SRE] set up parameter group
  • [Dev] Perform blue/green deployment and switchover
  • [Dev] Clean up tasks
  • [SRE] Terraform state manipulation
  • [SRE] Update sheet

Notes:

SRE runbook for publishing-api production - updated version of the runbook for publishing-api specifically in production
SRE runbook for publishing-api staging & integration - updated version of the runbook for publishing-api specifically in integration & staging
Developer runbook for production - updated version of the runbook for publishing-api specifically in production
Developer runbook for staging & integration - updated version of the runbook for publishing-api specifically in integration and staging

Metadata

Metadata

Labels

plannedWork scheduled for an upcoming sprint.

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions