> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/install/10.2-install/pentaho-installation-overview-cp/hyperscalers-landing-page/installing-pentaho-on-aws/installing-the-platform-or-pdi-server-on-aws/create-an-rds-database.md).

# 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](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.PostgreSQL.html) and apply the settings in the table below.

| Section                 | Actions                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Create database         | <p>Choose <strong>Standard create</strong>.</p><p>Select the <strong>PostgreSQL</strong> engine.</p><p>Set the engine version to a PostgreSQL version supported by the <strong>Components reference</strong> found in the <strong>Try Pentaho Data Integration and Analytics</strong> document, such as <strong>PostgreSQL 13.5-R1</strong>.</p>                                                                                                  |
| Templates               | <p>It is recommended to select the <strong>Free tier</strong> option.</p><p><strong>Note:</strong> For this installation, the <strong>Free tier</strong> 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.</p>                                                                                                                            |
| Settings                | <p>Set the DB instance identifier.</p><p>Retain the default user name <strong>postgres</strong> and set the <strong>Master password</strong>.</p><p>Use the default password authentication setting.</p><p>Use the default values for the rest of the settings in this section.</p>                                                                                                                                                               |
| Instance configuration  | Use the default settings for each section.                                                                                                                                                                                                                                                                                                                                                                                                        |
| Storage                 | Use the default settings for each section.                                                                                                                                                                                                                                                                                                                                                                                                        |
| Connectivity            | <p>Set the <strong>Virtual private cloud (VPC)</strong> and the <strong>DB subnet group</strong> to any of the options available to you. If in doubt, use the default values.</p><p>Select <strong>Public access</strong>.</p><p>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.</p><p>For other options, use the default settings.</p> |
| Database authentication | Use the default setting **Password authentication**.                                                                                                                                                                                                                                                                                                                                                                                              |

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

3. From the AWS **Management Console connection** tab, record the database **Endpoint** and **Port** number in the [Worksheet for AWS hyperscaler](/install/10.2-install/pentaho-installation-overview-cp/hyperscalers-landing-page/installing-pentaho-on-aws/running-pdi-cli-on-aws/worksheet-for-aws-hyperscaler-common.md).


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.pentaho.com/install/10.2-install/pentaho-installation-overview-cp/hyperscalers-landing-page/installing-pentaho-on-aws/installing-the-platform-or-pdi-server-on-aws/create-an-rds-database.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.