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 production database to PostgreSQL 16 #15

Open
weaverba137 opened this issue Sep 17, 2024 · 2 comments
Open

Update production database to PostgreSQL 16 #15

weaverba137 opened this issue Sep 17, 2024 · 2 comments
Assignees

Comments

@weaverba137
Copy link
Member

The current production specprod database is based on PostgreSQL 11, which no longer supported. I have already created a Spin image based on PostgreSQL 16 and tested it on the Spin development cluster. The Dockerfile and related files are included in PR #14.

To avoid extended downtime on the existing production database, set up a separate database instance with persistent storage, load fuji, guadalupe and iron from pg_dump files, then proceed to load daily & kibo.

@weaverba137 weaverba137 self-assigned this Sep 17, 2024
@weaverba137
Copy link
Member Author

It might also be a good idea to re-create the pg_dump files. I recall there may have been minor changes applied to fuji, guadalupe and iron after they were loaded.

@weaverba137
Copy link
Member Author

As of today:

  • A new PostgreSQL 16 container has been created; it's called db2.
  • New pg_dump files for fuji, guadalupe and iron have been created and backed up to HPSS.
  • fuji, guadalupe and iron have been loaded into db2.

And remaining to do:

  • The intention is that db2 will be used to load kibo and daily.
  • After kibo is loaded and tile-based loading has been tested for daily, db2 will be renamed to db, at which point it will take over as the official specprod-db server.
  • Any old resources used by the previous PostgreSQL 11 container will be released.

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