-
Story
-
Resolution: Done
-
Major
-
None
-
None
As a user needing to upgrade the database, I want to provide a means to run a script in a pod containing bash and postgres client programs to monitor a database for availability and that it matches a required server version in order to run a post-upgrade SQL script.
After coordinating with SRE concerning the staging upgrade, I found that there is not currently a way to directly or indirectly connect to the staging database in order to run post-upgrade commands.
SRE had given the suggestion that a debug pod with the PostgreSQL client programs installed could be executed and connect to the database. As that sounded like the groundwork for potential automation of the post-upgrade task, a script should be written that will:
- Check that a database server is accepting connections
- Check that the database server is at a desired version in order to run the post-upgrade script
- blocks
-
COST-332 Upgrade Production Database to PostgreSQL 12
-
- Closed
-