Request: Postgres instance and s3 access for transportation team

hackoregon / civic-devops

Master collection point for issues, procedures, and code to manage the HackOregon Civic platform

MIT License

11 stars 4 forks source link

Closed danieldn closed 5 years ago

danieldn commented 5 years ago

Summary See https://docs.google.com/document/d/1L6WcZI_fOiT2R7QzNz57nTfPTSUcNpty6pfd2sPcMh4/edit#

Impact

Resource request

Tasks

Definition of Done

Approved developers of transportation team shall have access to s3 and postgres to complete their cards.

MikeTheCanuck commented 5 years ago

Manual RDS installation for now to workaround our CloudFormation testing problems:

DB instance identifier: transportation-2019-staging
Use case: dev/test (non-replicated)
DB engine: PostgreSQL 11.2-R1
DB instance class: db.t2.small
Allocated storage: 60GB
VPC: public-database
VPC security groups: hacko-public-database
log exports: Postgresql logs published to CloudWatch
Enable deletion protection
Endpoint address: transportation-2019-staging.caicgny9d8nv.us-west-2.rds.amazonaws.com All other settings at default.

SQL credentials will be distributed directly.

MikeTheCanuck commented 5 years ago

The application login role for this RDS instance has the following privileges:

MikeTheCanuck commented 5 years ago

Post-creation configuration steps:

create application login role
add PostGIS support: login through PGAdmin, browse to Databases > postgres > Extensions, right-click, choose Create > Extension, select postgis from the Name box and hit Save