Export to
Tuesday, February 13, 2024 at 6:15pm.
PDXPUG: Zero Downtime: Live Data and Server Migrations
Access Notes
Parking is available in front of the building. Please be prepared to show ID and sign in with security when entering the building.
Parking is available in front of the building. Please be prepared to show ID and sign in with security when entering the building for the "PDXPUG" meeting. We will be in the Columbia Room on the second floor.
Website
Description
Speaker: Grant Holly
Moving a live production dataset between servers is hard to do. I’m going to share a few examples of how I’ve been able to move data and workloads between servers without downtime, dropped writes, or stale reads. I had to break out more than a few Postgres tricks like logical replication, foreign data wrappers, and writable views, all of which we will be reviewing.
My goal is to share a few strategies that have worked and how they handle the common difficulties with moving live datasets. Please bring your own stories and questions and add to the conversation.