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 PRIVILEGESwithin 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.