Stand up Postgres DB in phdi-playground for TEFCA Connector

[DanPaseltiner]

We need a Postgres server for likely several databases in the future, but immediately we need a database to persist custom query templates created by our users. Therefore we need to stand up a Postgres DB in the AWS environment owned by Skylight that the phdi-playground repository currently deploys to.

Acceptance Criteria

• We can start with the smallest instance AWS RDS instance e.g. t2-micro
• The TEFCA Viewer is the only building block that will need DB access
• The DB should not be accessible from the public internet
• DB credentials can be provided to the TEFCA Viewer as environment variables
• The scope of this ticket does not include implementing a database schema or migrations
• Ultimately we should a Postgres RDS server with one database called query-templates (name might need some work)

[marycrawford]

@DanPaseltiner - I updated the instance from db.t2.micro to db.t3.micro since db.t2 is being phased out and Amazon is no longer going to support it past December 31, 2024. See Amazon doc and screenshot.

[marycrawford]

Secrets Manager is not part of this ticket. A future ticket will be created to update the architecture. Right now, we are using the random_string resource and will triple check to see what special character limits for Postgres and apply it to the code.