Minimizing Major Version Upgrade Downtime Utilizing Slony
Audience:
Topic:
Let's face it, major version upgrades can be a pain. Most people are familiar with the
dump/restore method, but if your database happens to be larger than a few GB, the
downtime required for dump/restore is likely going to exceed your maximum maintenance
window.
We'll briefly explore upgrade options including dump/restore, pg_upgrade and
logical replication tools like Slony and why I think Slony is currently the
best option. Then we'll run through a tutorial on how to use slony for
a major version upgrade with minimal downtime.
Room:
Room 107
Time:
Friday, March 3, 2017 - 15:00 to 16:00