/Users/pablo/Library/Mobile Documents/com~apple~CloudDocs/pablion-files/arrow/Coding/Cloud Service/AWS/AWS-RDS setup

• @2022-04-12
• Using official tutorial

Capability test

• Determine requirements

  • Resource requirements: The most common db.m6g from DB instance classes.
  • VPC, subnet, and security group: Testing "Default VPC"
  • High availability, IAM policies ,Open ports.
  • AWS Region: Testing with ~~EU~~ US East. Will deploy with US East.
  • DB disk subsystem: Magnetic (Standard Storage)
  • Provide access to your DB instance in your VPC
  • Port range: common DB ports (origin): 1433(SQL), 5432(postgres), 3306(MySQL). Source (IP): Anywhere. No outbound rules.
  • Creating an Amazon RDS DB instance: Setting up for Amazon RDS same thing as "official tutorial". To create a DB instance. Stopped here because there's one for postgres (link same as the first one of next bullet point).

  • Creating a PostgreSQL DB instance and connecting to a database on a PostgreSQL DB instance

    • Creation Master username=, psw= |Configuration|Value|Editable after database is created| |-------------|-----|----------------------------------| |Encryption|Enabled|No| |VPC|Default VPC (vpc-08c5fe4d2906b471b)|No| |Option Group|default:postgres-13|No| |Subnet Group|default-vpc-08c5fe4d2906b471b|Yes| |Automatic Backups|Enabled|Yes| |VPC Security Group|sg-05711f2f99988e64f|Yes| |Publically Accessible|No|Yes| |Database Port|5432|Yes| |DB Instance Identifier|BAN-db-test|Yes| |DB Engine Version|13.4|Yes| |DB Parameter Group|default.postgres13|Yes| |Performance Insights|Enabled|Yes| |Monitoring|Enabled|Yes| |Maintenance|Auto Minor Version Upgrade Enabled|Yes| |Delete Protection|Not Enabled|Yes|
    • Connecting to a PostgreSQL DB instance: Install pgAdmin, Object -> Create new Database, select PostgreSQL., just follow the guide. The only trouble I met is the solved in the next bullet point.
    • With Easy Create, the "Publicly Accessible" was set to "No" by default. Should change it like this (origin)