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