Create an RDS database

Use these instructions to create an Relational Database Service (RDS) database in AWS.

1. Create an RDS PostgreSQL database for Pentaho to use in the ECR.

   See the AWS instructions at Creating and connecting to a PostgreSQL DB instance and apply the settings in the table below.

Section	Actions
Create database	Choose Standard create. Select the PostgreSQL engine. Set the engine version to a PostgreSQL version supported by the Components reference found in the Try Pentaho Data Integration and Analytics document, such as PostgreSQL 13.5-R1.
Templates	It is recommended to select the Free tier option. Note: For this installation, the Free tier PostgreSQL database is used with a set of options as an example. However, you are free to use other database servers with different options as necessary.
Settings	Set the DB instance identifier. Retain the default user name postgres and set the Master password. Use the default password authentication setting. Use the default values for the rest of the settings in this section.
Instance configuration	Use the default settings for each section.
Storage	Use the default settings for each section.
Connectivity	Set the Virtual private cloud (VPC) and the DB subnet group to any of the options available to you. If in doubt, use the default values. Select Public access. Make sure that the VPC security groups selected have a rule enabling communication to the database through the PostgreSQL port, which is 5432 by default. For other options, use the default settings.
Database authentication	Use the default setting Password authentication.

2. Run the scripts in the `sql-scripts` folder in the distribution in the numbered order.

1. From the AWS Management Console connection tab, record the database Endpoint and Port number in the Worksheet for AWS hyperscaler.