# Postgres RDS Immersion Day

## Agenda

### Third Day - 10/4
| Start <img width=100/>| End <img width=100/>| Type <img width=100/> | Topic <img width=300/>| Link <img width=80/>|
| -------- | -------- | -------- | -------- |-------- |
| 9:00 AM | 9:45 AM | Presentation | Performance Monitoring |
| 9:45 AM | 9:45 AM | Lab | Environment Setup | [Link](https://rdspg.workshop.aws/2-foundation/lab1.5-client.html) |
| 9:45 AM | 10:30 AM | Lab | Monitor and Review Performance | [Link](https://rdspg.workshop.aws/2-foundation/lab6-monitoring.html) |
| 10:30 AM | 11:00 AM | Presentation | Security and Compliance |
| 11:00 AM | 11:30 AM | Presentation | Database Version Upgrades |
| 11:30 AM | 11:45 AM | End of Day | Next Steps |

## Temporary Accounts
Use the following link to obtain your temporary AWS account used for today's event.

[Temporary AWS Accounts](https://dashboard.eventengine.run/login?hash=bc0a-1887a6a284-e1)
Event Hash: bc0a-1887a6a284-e1

## Survey
We appreciate you taking a few minutes to fill out the following survey. Your feedback helps us improve these events.

https://survey.immersionday.com/cdrhASDnR

## Chime Room
Monday 10/4 - https://chime.aws/7067330103

## Related Documentation
[AWS Virtual Workshop - Running Production PostgreSQL databases on Amazon RDS for PostgreSQL](https://www.youtube.com/watch?v=1z1ZFVLUhv0)
[ReInvent 2020 - Deep Dive on PostgreSQL databases on Amazon RDS](https://www.youtube.com/watch?v=3JLPWOoiVB8)
[Monitoring RDS with CloudWatch](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/monitoring-cloudwatch.html)
[AWS Schema Conversion Tool (SCT)](https://aws.amazon.com/dms/schema-conversion-tool/)
[AWS Database Migration Service (DMS)](https://aws.amazon.com/dms/?nc=sn&loc=1)
[Babelfish for Aurora PostgreSQL](https://aws.amazon.com/rds/aurora/babelfish/)
[Supported PostgreSQL Extensions in RDS (by version)](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions)

## Previous Agenda

### Monday - 9/20

| Start <img width=100/>| End <img width=100/>| Type <img width=100/> | Topic <img width=300/>| Link <img width=80/>|
| -------- | -------- | -------- | -------- |-------- |
| 12:30 PM | 12:45 PM | Intro | Welcome and Introductions | |
| 12:45 PM | 1:30 PM | Presentation | Amazon RDS for Postgres Introduction | |
| 1:30 PM | 1:45 PM | Lab | Setup Lab Environment | [Link](https://rdspg.workshop.aws/1-prerequisites/task2.html) |
| 1:45 PM | 3:15 PM | Lab | Create RDS for PostgreSQL Database Instance | [Link](https://rdspg.workshop.aws/2-foundation/lab1-create.html) |
| 3:15 PM | 4:30 PM | Presentation | High Availability | |

### Tuesday - 9/21

| Start <img width=100/>| End <img width=100/>| Type <img width=100/> | Topic <img width=300/>| Link <img width=80/>|
| -------- | -------- | -------- | -------- |-------- |
| 8:40 AM | 9:25 AM | Presentation | Scaling and Operations | |
| 9:25 AM | 9:45 AM | Lab | Scaling and Optimizing CPU | [Link](https://rdspg.workshop.aws/2-foundation/lab2-scaling-replica.html) |
| 9:45 AM | 10:10 AM | Lab | High Availability | [Link](https://rdspg.workshop.aws/2-foundation/lab3-ha.html) |
| 10:10 AM | 10:25 AM | Break | | |
| 10:25 AM | 11:10 AM | Presentation | Backup and Recovery | |
| 11:10 AM | 11:40 AM | Lab | Backup and Recovery | [Link](https://rdspg.workshop.aws/2-foundation/lab4-backup.html) |