Create Aurora PostgreSQL Database

Aurora PostgreSQL database

Amazon Aurora PostgreSQL is a fully managed, PostgreSQL-compatible, and ACID-compliant relational database. Aurora PostgreSQL is a drop-in replacement for PostgreSQL and makes it simple and cost-effective to set up, operate, and scale your new and existing PostgreSQL deployments, thus freeing you to focus on your business and applications. Amazon RDS provides administration for Aurora by handling routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair.

All the activities in this section must be performed on AWS Management Console under us-west-2, Oregon region.

  1. From AWS Management console, select RDS service and click Create database.

RDS Main Screen

  1. Select Standard Create as the database creation method.

Select Target DB

  1. In the Engine options section, make the following selections.
    Option Value
    Engine type Amazon Aurora
    Edition Amazon Aurora with PostgreSQL compatability

Select Target DB

  1. In the Templates section, select Dev/Test.

Select Target DB

  1. In the Settings section, enter the following values:
    Setting Value
    DB cluster identifier mf-lab-db
    Master username postgres (keep as-is)
    Master password postgres
    Confirm password postgres

DB options

  1. In the DB instance size section, select Burstable classes (includes t classes) as the instance class.

DB options

  1. In the Connectivity section,
    • Select MF vpc from the dropdown for VPC.
    • Select MicroFocus-Aurora-DB-SG from the drop-down for existing VPC security groups.

DB options

  1. Under Additional configuration section,
    • Enter initial database name as ‘mflabdb’.
    • Disable Enhanced Monitoring (un-check the checkbox)

DB options Disable Monitoring

  1. Scroll to the bottom of the page and click Create database.

DB options

  1. Wait until the database status changes to Available.

DB Available

  1. Once the database is Available, click the DB identifier mf-lab-db and copy the Writer endpoint name and save it in a temporary file.

DB endpoint