AWS Relational Database Service (RDS)

Introduction

RDS is the classic SQL database system. It offers PostgreSQL, MySQL, and Amazon Aurora as the server variants. Designed to integrate with server-side software (i.e. Elastic Beanstalk).

Usage

• We currently have a single production database
• Uses PostgreSQL 12.10
• Currently connect to the server using pgAdmin to create backups
• To update the database, click “Modify”, and change the “DB engine version”

Future

• Upgrade to PostgreSQL 13
• Investigate how Heroku deploys databases