How mamonaco1973/aws-postgres works
This repository is Terraform infrastructure for deploying two managed PostgreSQL options on AWS and making them immediately usable for demos. The main workflow is to provision networking and credentials, create RDS PostgreSQL and Aurora PostgreSQL backends, then connect through pgweb and explore the Pagila sample database. The graph preserves the documented RDS replica and Aurora writer/reader distinction. Resource wiring is summarized from the README and file names; sampled source was limited to the diagram generator, so uncertain Terraform-level links are omitted.
Main entry points: postgres.tf RDS instance · aurora.tf Aurora writer · pgweb.tf pgweb client · networking.tf VPC networking
Components 16
Network & security
- VPC networking
01-rds/networking.tf - Security groups
01-rds/security.tf
Credentials
- Credentials secrets
01-rds/secret.tf - AWS roles
01-rds/role.tf
RDS PostgreSQL
- RDS PostgreSQL
01-rds/postgres.tf - RDS instance
01-rds/postgres.tf - Read replica
01-rds/postgres.tf
Aurora PostgreSQL
- Aurora cluster
01-rds/aurora.tf - Aurora writer
01-rds/aurora.tf - Aurora reader
01-rds/aurora.tf
Demo access
- pgweb provisioning
01-rds/pgweb.tf - pgweb installer
01-rds/scripts/install_pgweb.sh - pgweb client
01-rds/pgweb.tf - Pagila sample data
01-rds/data
Other components
- AWS operator
- Database explorer
Connections 27
- AWS operator → VPC networking: provisions
- AWS operator → Security groups: provisions
- AWS operator → Credentials secrets: provisions
- AWS operator → RDS PostgreSQL: provisions
- AWS operator → Aurora cluster: provisions
- AWS operator → pgweb provisioning: provisions
- RDS PostgreSQL → RDS instance: creates
- RDS PostgreSQL → Read replica: creates
- Aurora cluster → Aurora writer: creates
- Aurora cluster → Aurora reader: creates
- pgweb provisioning → pgweb installer: uses
- pgweb provisioning → pgweb client: provisions
- Database explorer → pgweb client: queries
- pgweb client → RDS instance: connects
- pgweb client → Aurora writer: connects
- Pagila sample data → RDS instance: loads sample
- Pagila sample data → Aurora writer: loads sample
- VPC networking → RDS instance: hosts
- VPC networking → Aurora writer: hosts
- VPC networking → pgweb client: hosts
- Security groups → RDS instance: guards access
- Security groups → Aurora writer: guards access
- Security groups → pgweb client: guards access
- Credentials secrets → RDS instance: stores credentials
- Credentials secrets → Aurora writer: stores credentials
- RDS instance → Read replica: replicates asynchronously
- Aurora writer → Aurora reader: shares storage