Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-21894

Stand up system for running CI tests against PostgreSQL-backed Gen3 Registries

    Details

    • Story Points:
      8
    • Team:
      Data Access and Database

      Description

      Like DM-21893, but for PostgreSQL, where I think the situation may be substantially easier because it might be possible to just stand up a PostgreSQL server inside the Jenkins VMs, and to configure that to let whatever's running inside Jenkins create and delete schemas in that server as necessary (adding Frossie Economou as a watcher in the hopes she can comment on the viability of that idea and/or alternatives, though I don't think we know yet who will take the lead on this from the MW side).

        Attachments

          Activity

          Hide
          jbosch Jim Bosch added a comment -

          I've been using testing.postgresql on DM-22508, which sets up a temporary PostgreSQL server in user-space, and I've been quite happy with that.  One just needs to conda install postgresql and pip install testing.postgresql to get that working in our stack, and maybe we can just get that done in Jenkins to enable the tests I'm adding on that ticket?  I don't know if it's possible to have special installs for Jenkins that wouldn't be included in other modes of building the stack.

          Show
          jbosch Jim Bosch added a comment - I've been using  testing.postgresql on DM-22508 , which sets up a temporary PostgreSQL server in user-space, and I've been quite happy with that.  One just needs to conda install postgresql and pip install testing.postgresql to get that working in our stack, and maybe we can just get that done in Jenkins to enable the tests I'm adding on that ticket?  I don't know if it's possible to have special installs for Jenkins that wouldn't be included in other modes of building the stack.

            People

            • Assignee:
              Unassigned
              Reporter:
              jbosch Jim Bosch
              Watchers:
              Andy Salnikov, Fritz Mueller, Jim Bosch, Michelle Gower, Tim Jenness
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:

                Summary Panel