Thursday Feb 15, 2024, Meetup: Zero Downtime: Live Data and Server Migrations

PDXPUG Feb 15, 2024: Zero Downtime: Live Data and Server Migrations
6:30pm:8:30pm

Please RSVP in MeetUp if you can:
https://www.meetup.com/pdxpug/events/299185648/

Location:

American Red Cross
3131 N Vancouver Ave, Portland, OR 97227

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.

Details:

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.

--
Mark Wong
EDB https://enterprisedb.com