Upgrade Postgres - Githubissues

visualize-admin / visualization-tool

The tool for visualizing Swiss Open Government Data. Project ownership: Federal Office for the Environment FOEN

https://visualize.admin.ch

BSD 3-Clause "New" or "Revised" License

35 stars 3 forks source link

Upgrade Postgres #2157

Open adintegra opened 2 months ago

adintegra commented 2 months ago

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

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

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 commented 3 weeks ago

Upcoming Maintenance Windows

02.06.-13.06.2025
07.07.-16.07