Navigating PostgreSQL End of Life: Upgrade Strategies and Best Practices
Presented by:
Vivek Singh
Vivek Singh is a Principal Database Specialist with AWS focusing on Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL engines. He works with enterprise customers providing technical assistance on PostgreSQL operational performance and sharing database best practices. He has over 17 years of experience in open source database solutions, and enjoys working with customers to help design, deploy, and optimize relational database workloads on AWS.
As PostgreSQL major versions reach End of Life annually, database administrators face critical upgrade decisions. This session provides a comprehensive guide to navigating PostgreSQL end-of-life scenarios and executing seamless upgrades. We'll explore proven strategies, best practices, and techniques for minimizing downtime during transitions for community PostgreSQL as well as Amazon Aurora and RDS for PostgreSQL databases. Discover the significant benefits of PostgreSQL 16, including performance enhancements and new features. I'll present comparative benchmarking results between PostgreSQL 12 and 16, offering valuable insights to inform your upgrade decisions. Whether managing small databases or large-scale deployments, this session equips you with the knowledge to confidently plan and execute your PostgreSQL upgrade strategy. Note: I delivered this session at the Dallas PostgreSQL User Group monthly meetup, which was attended by 11 people. The feedback indicated that the presentation was useful and should be shared with a larger audience.
- Date:
- 2025 March 11 13:00 EDT
- Duration:
- 50 min
- Room:
- Online
- Conference:
- 2025 Postgres World Webinar Series
- Language:
- Track:
- Ops
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 2)