Logical Replication lessons learned for the Data Warehouse
Presented by:
Pat Wright
Pat Wright is an Advocate with Redgate Software. He has been a database professional for 25 years, specializing in PostgreSQL for the past 10 years, after a long career with SQL Server. He has worked across large-scale SaaS platforms, early-stage startups, and a wide range of consulting engagements over the past decade. Pat currently serves as the Sponsor Coordinator for PGUS and as President of Utah Geek Events, and is a frequent speaker in both the PostgreSQL and SQL Server communities. His sessions draw on deep real-world experience with performance, automation, and operational best practices. Outside of tech, he enjoys photography, classic cars, and cycling.
No video of the event yet, sorry!
Logical Replication was released in Postgres version 10. We have been using it for a Data Warehouse system for the last year and this talk will show you how to set it up for a Data Warehouse system and some of the pitfalls you will run into. We will have the opportunity to discuss what replication you should be using depending on the work you are doing. Perhaps Logical Replication is not the best solution for what you are doing and some other form of replication would be better.
- Date:
- Duration:
- 50 min
- Room:
- Conference:
- Postgres Conference 2020
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Easy