Amazon Relational Database Service (Amazon RDS) for PostgreSQL - Troubleshooting

In this course, you will learn how to view configuration information, monitor performance, and gather diagnostic data about Amazon Relational Database Service (Amazon RDS) for PostgreSQL. You will also learn how to use this information to help troubleshoot common issues and provide effective support case details if you need to escalate an issue to Amazon Web Services (AWS) Support.

Course level: Advanced

Duration: 60 minutes

Activities

This course includes interactive learning objects, troubleshooting scenarios, videos, and resources for problem determination.

Course objectives

In this course, you will learn to do the following:

• Recognize and resolve issues with Amazon RDS for PostgreSQL.
• Employ best-practice troubleshooting methodologies when investigating RDS for PostgreSQL issues.
• Locate and apply available AWS Support documentation for RDS for PostgreSQL issues.
• Recognize and record relevant information to escalate RDS for PostgreSQL issues to the AWS Support team.

Intended audience

This course is intended for the following:

• Application developers who use Amazon RDS for PostgreSQL
• SysOps administrators who manage Amazon RDS for PostgreSQL deployments

Prerequisites

We recommend that attendees of this course have the following experience:

• Basic knowledge of Amazon RDS concepts
• Experience managing Amazon RDS for PostgreSQL deployments

Course outline

• How to Use This Course
• Overview of Amazon RDS for PostgreSQL
• Gathering Information with the AWS Management Console
• Gathering Information using the AWS CLI
• Monitoring Amazon RDS for PostgreSQL
• General Problem Determination
• Troubleshooting Replication Lag on Amazon RDS for PostgreSQL
• Troubleshooting Read Replica "canceling statement due to conflict with recovery" Log Errors
• Troubleshooting Autovacuum Skipping Tables or Dead Tuples on an RDS for PostgreSQL Instance
• Troubleshooting an Increasing MaximumUsedTransactionID Amazon CloudWatch Metric
• Troubleshooting Major Version Upgrade Failures
• Resources
• Support
• Contact Us