Skip to main content

Amazon RDS for PostgreSQL

Amazon RDS for PostgreSQL is a service on AWS that that makes it easier to set up, operate, and scale a PostgreSQL database in the AWS Cloud.

This page walks you through adding an Amazon RDS for PostgreSQL Database as a data source to Ahana Cloud for Presto.

Step 1: Select Amazon RDS for PostgreSQL as the Connector Type

  1. In the Ahana SaaS Console, select Data Sources.
  2. Select Add Data Source.

Data Sources

  1. Select Amazon RDS for PostgreSQL.

Configure PostgreSQL

Step 2: Configure the data source details

  1. Give your data source a Name - This will be used to derive the catalog name used for Presto.
  2. Give a Description about this data source.

Configure Amazon RDS for PostgreSQL

Step 3: Configure the PostgreSQL database access details

  1. Enter the Endpoint information for your Amazon RDS for PostgreSQL database.
    • e.g. ahana-demo-db.abcdefghijkl.us-east-1.rds.amazonaws.com
Find the connection string to the Amazon RDS for PostgreSQL database

Navigate to the Amazon RDS console

In the sidebar menu, select Databases, then select the PostgreSQL database you want to connect to.

In the Connectivity & Security section, copy the endpoint information.

Paste the endpoint information into the Endpoint text field on the Ahana Cloud console.

Get the Database endpoint Information from the Amazon RDS Console

caution

This Endpoint needs to be accessible from the VPC where the Presto clusters are running.

  1. If required, enter extra Configuration Properties to the database.
  2. Enter the Database Name.
  3. Enter the User and the Password for the database.

Configure Amazon RDS for PostgreSQL

Step 4: Add the data source

When you have configured the data source, select Add Data Source.

You can now connect to this data source from your Presto clusters.