AWS RDS (PostgreSQL)

Overview

Amazon Relational Database Service (Amazon RDS) is a collection of managed services that makes it simple to set up, operate, and scale databases in the cloud. RDS offers several features and is one of the most popular managed database providers

AWS RDS for PostgreSQL is a managed Postgres database service which can be used to set up, operate, and scale a postgresql database in the cloud with just a few clicks

Get Started with AWS RDS for PostgreSQL

1. Sign up for an account with AWS. AWS offers a free tier to get you started and you can upgrade to paid services when needed.

2. Create a RDS for PostgreSQL instance in your account. Here are some AWS tutorials to help you get started

   • Tutorial 1 - Creating a PostgreSQL DB instance

   • Tutorial 2 - Getting started with a PostgreSQL instance

   • Important Notes -

     • Remember to choose "PostgreSQL" as the engine type and not "Aurora (PostgreSQL Compatible)" to get started

     • You can choose "Free tier" as the template for your instance if you plan to use this for evaluation purposes with Neurelo

     • You don't need this DB to be connected to an EC2 instance

     • Use Password authentication for the database authentication method

     • Remember the username and password used when creating this instance. You will need these to connect your DB to Neurelo

     • You can specify the database name under Additional Configuration -> Database options

     

To enable Neurelo to connect to your AWS RDS instance, please make sure that the Neurelo IP addresses are enabled in your security groups to connect, or make the instance publicly accessible (not recommended -- use with caution only for testing purposes)

Collect PostgreSQL connection details from the AWS Console

1. To connect your newly created instance to Neurelo, you will need the following information

   • Host / Endpoint for the DB instance

   • Port

   • Username

   • Password

   • Database name

2. Login to the AWS console to fetch the host/endpoint and the port. You will need to remember the username, password and database name used when creating the instance.

Add the AWS RDS for PostgreSQL instance as a Data Source in a Neurelo Project

For each new project in Neurelo, you can utilize the Quick Start feature, a guided wizard for step-by-step onboarding, including adding a new Data Source like AWS RDS for PostgreSQL. Additionally, you can create new Data Sources anytime within your project from the left navigation panel.

Connecting AWS RDS for PostgreSQL to Neurelo with the Database Connection details

1. Login to your Neurelo Dashboard

2. Choose the project where you want to add a new data source or create a new project for this purpose.

3. For new projects, follow the Quick Start Guide and click on "Connect Data Source" button. For existing projects, navigate to "Data Sources" from the left navigation bar in the project and click on the "New" button and provide the details needed.

4. Please refer to this page for additional information.