Upgrade to Pro — share decks privately, control downloads, hide ads and more …

PostgreSQL HA

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for bjreath bjreath
November 21, 2012
Programming
0
210

PostgreSQL HA

Avatar for bjreath

bjreath

November 21, 2012
Tweet

More Decks by bjreath

See All by bjreath
Object-Oriented Design
Avatar for bjreath bjreath
2
140
The Rails View
Avatar for bjreath bjreath
1
130

Other Decks in Programming

See All in Programming
Amazon Bedrockを活用したRAGの品質管理パイプライン構築
Avatar for とすり tosuri13
4
250
360° Signals in Angular: Signal Forms with SignalStore & Resources @ngLondon 01/2026
Avatar for Manfred Steyer manfredsteyer
PRO
0
120
なぜSQLはAIぽく見えるのか/why does SQL look AI like
Avatar for florets1 florets1
0
450
Package Management Learnings from Homebrew
Avatar for Mike McQuaid mikemcquaid
0
210
Fragmented Architectures
Avatar for Denys Poltorak denyspoltorak
0
150
humanlayerのブログから学ぶ、良いCLAUDE.mdの書き方
Avatar for Yuto tsukamoto1783
0
180
今から始めるClaude Code超入門
Avatar for 448jp | OKI Yoshiya 448jp
7
8.4k
20260127_試行錯誤の結晶を1冊に。著者が解説 先輩データサイエンティストからの指南書 / author's_commentary_ds_instructions_guide
Avatar for nash_efp nash_efp
0
900
CSC307 Lecture 05
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
490
React 19でつくる「気持ちいいUI」- 楽観的UIのすすめ
Avatar for Hiroshi Morishige himorishige
11
5.9k
16年目のピクシブ百科事典を支える最新の技術基盤 / The Modern Tech Stack Powering Pixiv Encyclopedia in its 16th Year
Avatar for ahu ahuglajbclajep
5
990
AI & Enginnering
Avatar for codelynx codelynx
0
110

Featured

See All Featured
What’s in a name? Adding method to the madness
Avatar for The Alliance productmarketing
PRO
24
3.9k
How to optimise 3,500 product descriptions for ecommerce in one day using ChatGPT
Avatar for Katarina Dahlin katarinadahlin
PRO
0
3.4k
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
0
740
職位にかかわらず全員がリーダーシップを発揮するチーム作り / Building a team where everyone can demonstrate leadership regardless of position
Avatar for MADOX madoxten
56
50k
Bash Introduction
Avatar for André Augusto Costa Santos 62gerente
615
210k
Leo the Paperboy
Avatar for Maya Tellez mayatellez
4
1.4k
First, design no harm
Avatar for Per Axbom axbom
PRO
2
1.1k
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
698
190k
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
187
22k
The Impact of AI in SEO - AI Overviews June 2024 Edition
Avatar for Aleyda Solis aleyda
5
730
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
34
9.1k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
32
2.8k

Transcript

  1. PostgreSQL Log Shipping Brian Reath CCI Systems, Inc. Wednesday, November

    21, 12

  2. HA Techniques • Shared Disk • File System Replication (DRBD)

    • Transaction Log Shipping (WAL) Wednesday, November 21, 12

  3. Log Shipping • Master - continuous archive mode • Slave(s)

    - continuous recovery mode • warm standby • File-based versus streaming Wednesday, November 21, 12

  4. Hot Standby • Allows standby servers to service read queries

    • Useful for distributing read load across database servers • Asynchronous behavior may cause inconsistency across nodes Wednesday, November 21, 12

  5. Node Promotion • pg_ctl promote • Virtual IPs • Heartbeat

    / Pacemaker • keepalived Wednesday, November 21, 12

  6. Master-Slave with Rails • Master services all reads & writes

    • Master writes & slaves read • Octopus gem • Round-robin read query assignment • Introduces complexities Wednesday, November 21, 12

  7. References • PostgreSQL 9.2 Docs • Backup and Restore •

    High Availability, Load Balancing, and Replication Wednesday, November 21, 12