UNCLASSIFIED - NO CUI

Create an RDS Postgres Cluster / Database for CI runs

As a bigbang package developer, I need a PostgreSQL database object provided by the package and umbrella testing pipelines, so that I can test my package against a known working database inside of a pipeline. Without this, we are forced to maintain internal references in our package charts to builtin postgresql modules, which cause various maintenance headaches.

Acceptance Criteria

When a package pipeline or bigbang umbrella package mergeback pipeline is created, the following objects are automatically provisioned for and provided to the pipeline:

  • A PostgreSQL RDS database. This does not need to be an entire RDS instance unique to the pipeline, it can be a single database inside of an existing instance.
  • The hostname and port number for the RDS DB in question
  • A set of authentication credentials for the RDS DB in question that provides ALL PRIVILEGES within the specific database

When a package pipeline completes, the PostgreSQL RDS database is destroyed.

Additional Notes

For CI, a "random" database name will be used at run time by the CI postgres user. The database name will be prefixed with the date . This will allow some process to clean up old database each night.