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.

  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 ba-murach-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 BluAge-vpc from the drop-down.

DB options

  1. Under Additional configuration section,
    • Enter initial database name as ‘murachs’.
    • 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 ba-murach-db and copy the Writer endpoint name and save it in a temporary file.

DB endpoint

The writer endpoint needs to be updated in the server.xml file of the Tomcat server in next chapter (Deploy in Tomcat)