desihub / specprod-db

Interface, ingestion and Spin configuration for the spectroscopic production database.
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

Update production database to PostgreSQL 16 #15

Open weaverba137 opened 1 week ago

weaverba137 commented 1 week ago

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 commented 1 week ago

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 commented 2 days ago

As of today:

And remaining to do: