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.
- From AWS Management console, select RDS service and click Create database.
- Select Standard Create as the database creation method.
- In the Engine options section, make the following selections.
||Amazon Aurora with PostgreSQL compatability
- In the Templates section, select Dev/Test.
- In the Settings section, enter the following values:
|DB cluster identifier
||postgres (keep as-is)
- In the DB instance size section, select Burstable classes (includes t classes) as the instance class.
- 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.
- Under Additional configuration section,
- Enter initial database name as ‘mflabdb’.
- Disable Enhanced Monitoring (un-check the checkbox)
- Scroll to the bottom of the page and click Create database.
- Wait until the database status changes to Available.
- 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.