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

PostgreSQL HA

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for bjreath bjreath
November 21, 2012
Programming
220
0

PostgreSQL HA

Avatar for bjreath

bjreath

November 21, 2012

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
20260514_its_the_context_window_stupid.pdf
Avatar for heita heita
0
1k
AgentCore Optimizationを始めよう！
Avatar for matsukada licux
3
240
関係性から理解する"同一性"の型用語たち
Avatar for pvcresin pvcresin
1
170
SkillsをS3 Filesに置く時のあれこれ
Avatar for watany watany
3
1.6k
TypeScriptだけでAIエージェントを作る フロント・エージェント・インフラのフルスタック実践
Avatar for Har1101 har1101
3
490
Oxlintはいかにしてtsgolintのlint ruleを呼び出しているのか
Avatar for syumai syumai
0
210
継続的な負荷検証を目指して
Avatar for Kazuhiko Yamashita pyama86
3
1.2k
20260514 - build with ai 2026 - build LINE Bot with Gemini CLI
Avatar for LINE Developers Taiwan line_developers_tw
PRO
0
450
ハーネスエンジニアリングとは？
Avatar for kinopee kinopeee
13
7.1k
新規プロダクトを高速で生み出すハーネスエンジニアリング
Avatar for Ryohei Ikegami seanchas116
2
140
Hive Metastoreを通して学ぶIceberg REST Catalog ― 仕様から実装まで
Avatar for okumin okumin
0
140
「OSSがあるなら自作するな」は AI時代も正しいか ── Build vs Adopt の新しい判断基準
Avatar for Kumo Ishikawa kumorn5s
7
2.7k

Featured

See All Featured
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
33
1.7k
Mozcon NYC 2025: Stop Losing SEO Traffic
Avatar for Sam Torres samtorres
0
230
コードの90%をAIが書く世界で何が待っているのか / What awaits us in a world where 90% of the code is written by AI
Avatar for r-kagaya rkaga
61
44k
Navigating Weather and Climate Data
Avatar for Ryan Abernathey rabernat
0
190
How to audit for AI Accessibility on your Front & Back End
Avatar for davetheseo davetheseo
0
370
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
302
52k
Future Trends and Review - Lecture 12 - Web Technologies (1019888BNR)
Avatar for Beat Signer signer
PRO
0
3.5k
Performance Is Good for Brains [We Love Speed 2024]
Avatar for Tammy Everts tammyeverts
12
1.6k
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
Designing for Timeless Needs
Avatar for Cassini Nazir cassininazir
1
220
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.2k
Navigating the moral maze — ethical principles for Al-driven product design
Avatar for Skipper Chong Warson skipperchong
2
360

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