Logical Replication lessons learned for the Data Warehouse
Pat Wright has been a DBA for the past 15+ years and working in the Big Data space with Hadoop/Elastic search for the past 3 years. Pat has been working on Postgres for the last 2 years and runs the local postgres users group. Pat has been a SQL Server MVP, PASS Board of director and organizer of several users groups.
Pat has a night job running Utah Geek Events(501c(3)). Which helps to run events for the community. Utah Geek Events partners with Utah SQL Saturday, Sharepoint Saturday, Utah game jam and many other conferences and user groups.
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.
- 50 min
- Postgres Conference 2020
- Ops and Administration