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

PostgreSQL HA

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
AtCoder Conference 2025
Avatar for shindannin shindannin
0
960
Python札幌 LT資料
Avatar for t3tra t3tra
7
1.1k
AtCoder Conference 2025「LLM時代のAHC」
Avatar for Yuki Imajuku imjk
2
680
AIエージェントの設計で注意するべきポイント6選
Avatar for Har1101 har1101
6
3.2k
CSC307 Lecture 04
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
650
Unicodeどうしてる？ PHPから見たUnicode対応と他言語での対応についてのお伺い
Avatar for てきめん tekimen youkidearitai
PRO
0
870
Graviton と Nitro と私
Avatar for maroon1st maroon1st
0
170
フルサイクルエンジニアリングをAI Agentで全自動化したい 〜構想と現在地〜
Avatar for Kaito Minatoya kamina_zzz
0
370
Findy AI+の開発、運用におけるMCP活用事例
Avatar for starfish719 starfish719
0
2.2k
ThorVG Viewer In VS Code
Avatar for Nor-s nors
0
710
0→1 フロントエンド開発 Tips🚀 #レバテックMeetup
Avatar for 弁護士ドットコム bengo4com
0
500
AI Agent Dojo ＃4: watsonx Orchestrate ADK体験
Avatar for Akira Onishi (IBM) oniak3ibm
PRO
0
130

Featured

See All Featured
Practical Tips for Bootstrapping Information Extraction Pipelines
Avatar for Matthew Honnibal honnibal
25
1.7k
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
49
Code Review Best Practice
Avatar for Trisha Gee trishagee
74
19k
Ethics towards AI in product and experience design
Avatar for Skipper Chong Warson skipperchong
2
180
KATA
Avatar for Megan Lloyd mclloyd
PRO
33
15k
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
0
2.3k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
408
66k
svc-hook: hooking system calls on ARM64 by binary rewriting
Avatar for Akira Moroo retrage
1
75
30 Presentation Tips
Avatar for Ian Lurie portentint
PRO
1
190
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
40
2.2k
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
140
The #1 spot is gone: here's how to win anyway
Avatar for Tamara Novitovic tamaranovitovic
2
890

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