Uploaded image for project: 'Cost Management'
  1. Cost Management
  2. COST-379

Create a watcher script to automate post-database-upgrade tasks

XMLWordPrintable

    • COST Sprint 51

      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:

      1. Check that a database server is accepting connections
      2. Check that the database server is at a desired version in order to run the post-upgrade script

              hproctor HAP Proctor (Inactive)
              hproctor HAP Proctor (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: