Outline updated November 2026

Foundation21 hours delivered over 3-5 daysLive, online or on-site

Request this course

Amazon RDS for PostgreSQL

Class Duration

21 hours of live training delivered over 3-5 days to accommodate your scheduling needs

Student Prerequisites

  • No prior experience with PostgreSQL or AWS is necessary
  • Students should have a basic understanding of SQL, relational databases, and cloud computing

Target Audience

DBAs, cloud and platform engineers, SREs, and backend engineers who are new to PostgreSQL or to Amazon RDS and will run it in production. For self-managed engine internals, pair this with PostgreSQL for Administrators. Teams on Azure can compare Azure PostgreSQL Flexible Server.

Description

This course teaches PostgreSQL administration on Amazon RDS. It is for DBAs and engineers who run RDS for PostgreSQL in production. Students create instances and Multi-AZ deployments, manage parameter groups, and migrate data. They secure access with IAM authentication and Secrets Manager, monitor with CloudWatch Database Insights, and pool connections with RDS Proxy. Later modules cover backups, cross-Region recovery, Blue/Green upgrades, and planning for RDS Extended Support.

Learning Outcomes

  • Choose between Single-AZ, Multi-AZ, and read replica deployments.
  • Provision and configure RDS for PostgreSQL instances and parameter groups.
  • Secure databases with TLS, KMS, IAM authentication, and Secrets Manager.
  • Migrate data to RDS with native tools, Amazon S3, and AWS DMS.
  • Monitor and diagnose workloads with CloudWatch Database Insights.
  • Upgrade engine versions with Blue/Green Deployments.
  • Tune performance and cost through storage, instance class, and RDS Proxy.
  • Design and test backup and cross-Region recovery strategies.
  • Troubleshoot common connectivity, performance, and replication problems.

Training Materials

All students receive comprehensive courseware covering all topics in the course. Courseware is distributed via GitHub in the form of documentation and extensive code samples. Students practice the topics covered through challenging hands-on lab exercises.

Software Requirements

Students will need a free, personal GitHub account to access the courseware. Students are provided a cloud-based environment for all demonstrations and lab exercises. The course is taught on RDS for PostgreSQL 18, with notes for teams still running earlier major versions.

Training Topics

PostgreSQL Administration on RDS

  • PostgreSQL overview
  • PostgreSQL architecture
  • Key PostgreSQL features
  • Key RDS for PostgreSQL features
  • Choosing RDS for PostgreSQL or Aurora PostgreSQL

Create a Database Server

  • What is an Amazon RDS DB instance?
  • Production vs. development instances
  • Single-AZ instances
  • Multi-AZ DB instance deployments
  • Multi-AZ DB clusters with readable standbys
  • Read replicas

Create a Database

  • Creating a database
  • Database parameters
  • Supported extensions
  • Trusted Language Extensions with pg_tle

Export/Import Data

  • Migrating to Amazon RDS
  • Native dump and restore
  • AWS Database Migration Service
  • Exporting data to S3
  • Importing data from S3

Configuration and Maintenance

  • Self-managed vs. managed databases
  • No direct access to postgresql.conf
  • Parameter groups
  • Configuring pgAudit
  • Instance maintenance and maintenance windows
  • Database maintenance

Engine Version Management

  • Automatic and manual minor version upgrades
  • Major version upgrades
  • Blue/Green Deployments for low-downtime upgrades
  • RDS Extended Support and upgrade planning

Security

  • Encryption in transit with TLS
  • Encryption at rest with AWS KMS
  • Column-level encryption with pgcrypto
  • IAM database authentication
  • Master credentials in AWS Secrets Manager
  • VPC, subnet groups, and security groups

Connection Management

  • Connection limits and connection storms
  • Connection pooling with RDS Proxy
  • Faster failover with RDS Proxy
  • IAM authentication through RDS Proxy
  • RDS Proxy vs. self-managed PgBouncer

Performance Tuning

  • Storage autoscaling
  • General Purpose and Provisioned IOPS storage
  • Instance class selection
  • Query and index tuning on RDS

Backup and Restore

  • Automated backups
  • Manual snapshots
  • Point-in-time recovery
  • Cross-Region snapshot copies
  • Cross-Region automated backup replication
  • Restoring from a snapshot
  • Restoring data from S3
  • Restoring from a self-managed server

Monitoring and Logging

  • Amazon CloudWatch metrics and alarms
  • Enhanced Monitoring
  • CloudWatch Database Insights
  • Standard and Advanced modes
  • Database load, wait events, and top SQL
  • The Performance Insights API
  • Log exports to CloudWatch Logs
  • pgAudit logs

Connecting to PostgreSQL

  • The psql command line
  • pgAdmin
  • DBeaver
  • Enabling remote access
  • Connecting to RDS from EC2

Troubleshooting

  • Common connectivity issues
  • Performance issues
  • Storage problems
  • Backup and restore failures
  • Replication and read replica issues
  • Authentication and authorization errors
  • Instance availability and failures

Best Practices

  • Security
  • Performance
  • Backup and recovery
  • Monitoring
  • Maintenance and upgrades
  • High availability and disaster recovery
  • Cost management
  • Schema management and version control

Private team training

Bring this course to your team

Tell us about your team and we will tailor this outline to your tools, stack, and schedule. Courses can also be combined into a longer program.

  1. Tell us what you needYour tools, stack, team size, and timeline.
  2. We send a proposalA course or program, an outline adjusted to your team, and possible dates.
  3. Your team trains liveOnline or on-site, with courseware for every student.

Prefer to talk? Call +1 434-509-6890 or email help@cloudcontraptions.com.

We reply within 1 business day.

Training partner?