Create AWS RDS Multi-AZ

1. Go to AWS RDS console.

2. In the left sidebar,

• Choose Databases.
• Click Create database.

3. In the Choose a database creation method section, select Standard create.

4. In the Engine options section,

• For Engine type, select PostgreSQL.

• For Engine Version, select PostgreSQL 16.3-R2.

5. In the Templates section, select Production.

6. In the Availability and durability section, select Multi-AZ DB instance.

7. In the Settings section,

• For DB instance identifier, enter awsome-books.
• For Master username, enter postgres.
• For Credentials management, choose Managed in AWS Secrets Manager - most secure.

8. In the Instance configuration section, select Burstable classes (includes t classes) and db.t3.micro.

9. In the Storage section,

• For Storage type, select General Purpose SSD (gp3).
• For Allocated storage, enter 20.

10. In the Connectivity section,

• For Virtual private cloud (VPC), select the VPC named fcj.

• For DB subnet group, choose awsome-books.
• For Public access, select No.
• For VPC security group (firewall), select Choose existing.
• For Existing VPC security groups, select fcj-db.

11. In the Monitoring section, turn off Turn on Performance Insights.

12. In the Additional configuration section,

• For Initial database name, enter awsome_books.

• For Deletion protection, turn off Enable deletion protection (do not do this in real world projects).

13. Scroll down to the bottom, click Create database.

It migh take a while to create AWS RDS intances and the secret in AWS Secrets Manager.