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.
- 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.
Option |
Value |
Engine type |
Amazon Aurora |
Edition |
Amazon Aurora with PostgreSQL compatability |

- In the Templates section, select Dev/Test.

- 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 |

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

- In the Connectivity section, select BluAge-vpc from the drop-down.

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

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