POSTGRES OPEN

SEPT 16TH - 18TH ・ DALLAS

Register! Sponsors Schedule!

Session

Back

The Bones of Highly Available Postgres

Date: 2015-09-18
Time: 10:30 - 11:20
Room: Houston Ballroom A
Level: Intermediate

What is High Availability? More than anything else, it's a mindset. It's usually expensive, often cumbersome, and always depends on a rigorous architecture. Do you have the tenacity to build it?

In this talk, we'll discuss all of the necessary pieces of a highly available PostgreSQL system, why each is a necessary component, and what happens if something is omitted. How many servers? Where should WAL files go? How should we organize backup files? What configuration settings facilitate all of this? Do I need another data center? All of these questions are answered, along with quite a few more.

Also, be ready to laugh; many anecdotes regarding real unfortunate disasters will abound.

Speaker

Shaun Thomas