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
