About
Upgrading from PostgreSQL 11 to 16 can be an easy process, such as a dump restore, but when instance numbers and sizes increase, this can push organizations to maintain older PostgreSQL versions longer than expected. Avoiding technological debt is crucial for maintaining a robust and scalable database architecture. This session will present a real-world scenario on how to design an architecture that allows for easy migration between PostgreSQL versions. By using load balancers like HAProxy for connection management, PgBouncer for connection pooling, and automated logical replication for testing and migration, we can achieve seamless upgrades and minimize downtime. Additionally, we will explore how the new `pg_create_subscriber` feature in PostgreSQL 17 will further simplify this process, making future migrations even more efficient. The ultimate goal is to upgrade to new releases as soon as possible and allow developers to run all the necessary tests easily, simplifying the rollback process..
0:00:00 Slide 1
0:02:10 Slide 2
0:03:20 Slide 3
0:04:36 Slide 4
0:07:22 Slide 5
0:08:44 Slide 6
0:11:37 Slide 7
0:14:45 Slide 8
0:22:04 Slide 9
0:24:20 Slide 10
0:30:58 Slide 11
The talk
Credits and licence
- Institution
- CERN
- Department
- Visitor badges
- Speaker
- Adrien Obernesser
- Year
- 2025
- Language
- English
- Subjects
- Art, architecture and design
- Source
- CERN
- Licence
- CERN, as CERN states it. CERN's terms
- Attribution
- © CERN. CERN provides its audiovisual media free of charge for educational and informational use, credited to CERN; this lecture is shown in CERN's own player.
- Who can watch
- CERN gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed