NextGen Knowledge Center

Amazon Relational Database Service (RDS)

  1. To create your Postgres database in AWS, first sign into your account and search for RDS in the AWS Management Console.
  2. Click Databases on the left sidebar.
  3. Click the orange Create database button on the top right side of the page. Now you can start selecting options for your new database.
  4. Select Standard Create to customize the database configuration.
  5. Select PostgreSQL to create a Postgres database, then leave the default version.
  6. Select a template for your use case
    • Production - For production-grade deployments.
    • Dev/Test - For development, testing and performance measurements.
  7. In Settings enter the following:
    • DB Instance Identifier - prod-mirthdb
    • Master Username - postgres (username for your database such as admin, dev, qatest, etc..)
    • Master Password - XXXXXX (Password for your database)
  8. DB Instance Size - The DB instance class determines the computation and memory capacity of an Amazon RDS database instance. The database instance class you need depends on your processing power and memory requirements. For more details please refer to the following:https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Concepts.DBInstanceClass.html
  9. Storage Size - Specify the storage requirements for your database. You also have the option to enable storage autoscaling so that your database is dynamic and scales automatically.
    • Storage type - SSD
  10. Availability & Durability - This option is to create a standby database in case of an outage so that your database is always up and functioning.
  11. Connectivity - Specify the following connectivity configurations:
    • VPC — the VPC that defines the virtual networking environment for this DB instance
    • Subnet group — the subnet group that defines which subnets and IP ranges the DB instance can use
    • Public accessibility — whether the database is publicly accessible
    • VPC security group — the security groups that will allow incoming traffic outside your VPC
    • Availability zone — improves high availability by isolating failures from other Availability Zones
    • Database port — the TCP/IP port that the DB instance will use for application connections
  12. Database authentication - In this section, choose how you would like to authenticate your database credentials from the following options:
    • Password authentication — Manage your database user credentials through your DB engine’s native password authentication features.
    • Password and IAM database authentication — Manage your database user credentials through your DB engine’s native password authentication features and IAM users and roles.
    • Password and Kerberos authentication — Manage your database user credentials through your DB engine’s native password authentication features and an AWS Managed Microsoft AD created with AWS Directory Service. This way, you can centrally store and manage user credentials, instead of individually for each DB instance.
    • Select Password Authentication
  13. Expand Additional Configurations.
  14. Database options:
    • Initial database name - mirthdb
  15. Backup - Ensure that the Enable automatic backup option is enabled.
  16. Deletion Protection - Ensure that his option is enabled.
  17. Click Create Database. Wait a few minutes. The Database creation may take a while.
  18. Go to RDS -> Click Databases in the left panel -> Select prod-mirthdb (or your DB instance name)