AWS RDS (PostgreSQL)
Last updated
Last updated
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
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.
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)
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
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.
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.
Login to your Neurelo Dashboard
Choose the project where you want to add a new data source or create a new project for this purpose.
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.
Please refer to this page for additional information.
