Export or edit this event...

PDXPUG: Zero Downtime: Live Data and Server Migrations

American Red Cross
3131 N Vancouver Ave
Portland, OR 97227, USA (map)

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.

Share

Tags