Skip to content
This repository has been archived by the owner on Mar 12, 2024. It is now read-only.

Backup and upgrade ceqr-data Postgres database cluster #170

Closed
TylerMatteo opened this issue Oct 20, 2023 · 2 comments
Closed

Backup and upgrade ceqr-data Postgres database cluster #170

TylerMatteo opened this issue Oct 20, 2023 · 2 comments

Comments

@TylerMatteo
Copy link

TylerMatteo commented Oct 20, 2023

We need to upgrade the ceqr-data postgres cluster in Digital Ocean off of version 11 before it reaches End of Life. According to DO's built-in upgrade functionality, we can automatically upgrade to v13, which is supported until Nov 13, 2025.

Image

Steps

  1. Download backups of the ceqr-data and ceqr_data_staging databases in the ceqr-data cluster
  2. Verify that you can restore from those backups by restoring them to a local postgres cluster
  3. Upload the backups to the ae-data-backups Space in digital ocean under the ceqr-data folder
  4. Upgrade the ceqr-data cluster to version 13 by navigating to the overview page for the cluster in DO, clicking "Show Available Upgrades", selecting PostgreSQL 13, and "Upgrade Now"
@TangoYankee
Copy link

I assigned this issue to myself. However, I do not have permission to update the Assignee field.

@TangoYankee
Copy link

TangoYankee commented Oct 26, 2023

Steps 1-3 are complete All steps are complete

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants