Practical Production-Quality PostgreSQL Updates Using Logical Replication with Minimum Downtime
Presented by:

Ildefonso Camargo
Ildefonso has been in IT-related jobs for over 25 years, with the last 14 years being focused on PostgreSQL and technologies related to it at Command Prompt. He holds an Electronics Engineer degree, having spent all of his university years working in research labs related to computing (from IT to AI). He is originally from Venezuela and now lives in the Sunshine State. He is married, has two children, and a cat named Serenade. He is a musician, with experience in classical and folkloric music, knows how to play the Oboe, the Mandolin, and the Venezuelan "Cuatro." When not solving problems for Command Prompt clients or helping his team mates, he can probably be found praising The Lord with music at church, hiking with his wife or doing repairs at home.
No video of the event yet, sorry!
This live tutorial provides a practical, real-world approach to upgrading PostgreSQL using logical replication while minimizing downtime. The presenter will guide you through a step-by-step process, starting with an older PostgreSQL version (including pgBackRest backups) and culminating in a successful upgrade with minimal disruption to a sample application.
The setup will include the general pieces expected of a production system such as backup system (pgBackRest) and a replica (hot standby).
- Date:
- 2025 March 20 11:00 EDT
- Duration:
- 1 h 30 min
- Room:
- Space Coast 1&2
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Ops
- Difficulty:
- Medium