Kicking the Donkey of PostgreSQL Replication
Joshua D. Drake
Joshua D. Drake is a PostgreSQL Consultant and has been consulting on PostgreSQL since Postgres95. Throughout his PostgreSQL career he has performed a variety of functions within the community including releasing an O'Reilly book on PostgreSQL, being part of the sysadmins and advocacy teams. Further he ran a biannual conference series dedicated to PostgreSQL between the years of 2007 - 2011. He is a former Director for SPI (the non-profit for PostgreSQL.org). Lastly he is also a Founder of United States PostgreSQL.
No video of the event yet, sorry!
Have you ever wondered how to configure PostgreSQL Replication? Have you ever wondered how to configure PostgreSQL Log Shipping? Have you ever wondered: Which one is best for my application? Are you aware of the pitfalls of Replication? Where it breaks? When it will act in a way that is counter-intuitive? Do you know how to fix it? Do you know how to monitor it? If you have asked yourself any of these questions, this is the talk for you. We will step through PostgreSQL replication, the technology involved, the configuration parameters and how to configure it in a manner that isn't fragile. We will also cover gotcha's how to prepare for them and understanding what replication is doing. This talk is not not for the faint of heart. I will take a no holds barred approach and give you the real deal, the dirt and the gold that is one of the most sought after PostgreSQL features.
- 30 min
- PGConf NYC 2014