Upgrade Postgres

[adintegra]

Is your enhancement related to a problem? Please describe. The current version of Postgres used to store chart configurations is v11.5. This version was EOL'd in Nov 2023. Postgres should be upgraded to a currently supported version (e.g. 16 or 17) so that continued stability and security can be ensured.

Describe the solution you'd like Postgres running v16 or v17

Describe alternatives you've considered N/A

Use cases and impact N/A

Additional context A ticket has been opened with Abraxas to coordinate the upgrade activities: CS0406603 - Postgres Upgrade

[adintegra]

Upgrade Tasks

High-level sequence of activities required on each instance being upgraded. IXT activities are marked:

• [ ] Disable user access on WAF
• [ ] Dump visualization_tool database to backup file
• [ ] Verify backup file (IXT)
• [ ] Shutdown Visualize Docker container
• [ ] Create new Postgres data directory adjacent to current one
• [ ] Update docker-compose.yml (possibly IXT)
  • [ ] Update Postgres image v16 | v17
  • [ ] Update volume mount directory to new location
• [ ] Bring Docker container back up
• [ ] Restore visualization_tool database from backup
• [ ] Test application (IXT)
• [ ] Re-enable user access on WAF

[adintegra]

Status update (25.3.):

• Call w/ Abraxas 21.3. to coordinate upgrade activities
• Currently awaiting a timeline from them for when they have resources to support

[sosiology]

Upcoming Maintenance Windows

• 02.06.-13.06.2025
• 07.07.-16.07