My personal blog about Linux, opensource applications and related technologies. I have to solve the PostgreSQL HA and Redundancy few weeks ago. It has been written a lot about this topic, but I was not able to find some guide describing pgpool-II and repmgr. After reading some documents I build the solution which I'm going to describe. In short it contains the Master/Slave DB Streaming replication
タグ
- すべて
- * |ω・） (64)
- *2ch (42)
- *AWS (14)
- *English (23)
- *HW (17)
- *IT (28)
- *OSS (16)
- *PC (21)
- *PG (14)
- *UI (15)
- *amazon (11)
- *analysis (118)
- *application (30)
- *art (72)
- *blog (74)
- *book (259)
- *books (50)
- *business (1094)
- *career (110)
- *community (44)
- *company (384)
- *culture (125)
- *data (135)
- *database (58)
- *datamining (14)
- *design (373)
- *development (729)
- *economics (51)
- *event (316)
- *finance (185)
- *food (20)
- *gadget (107)
- *game (97)
- *google (22)
- *gourmet (15)
- *hardware (49)
- *item (40)
- *javascript (18)
- *life (76)
- *lifehack (66)
- *management (288)
- *marketing (401)
- *movie (42)
- *music (72)
- *network (31)
- *presentation (17)
- *programming (169)
- *reference (65)
- *research (30)
- *sales (50)
- *science (26)
- *software (89)
- *statistics (37)
- *study (106)
- *technology (113)
- *tips (65)
- *tools (58)
- *travel (29)
- *tutorial (124)
- *webサービス (428)
- *webデザイン (54)
- *web制作 (55)
- *wiki (11)
- *あとで試す (28)
- *あとで読む (95)
- *お役立ち (476)
- *これはすごい (89)
- *これは便利 (35)
- *まとめ (493)
- *アイデア (20)
- *イベント (32)
- *ツール (24)
- *デザイン (28)
- *ネタ (215)
- *ビジネス (39)
- *画像 (21)
- *素材 (20)
- *資料 (123)
- .net (11)
- 2ch (91)
- 3D (94)
- AR (28)
- AS (12)
- Alexa (17)
- Azure (28)
- BI (32)
- BlockChain (29)
- C++ (29)
- CG (13)
- CLI (53)
- ChatGPT (55)
- CircleCI (18)
- CloudWatch (16)
- DB (36)
- DTM (11)
- DWH (32)
- DX (40)
- Dataform (21)
- Deep Learning (21)
- Dify (69)
- EC (49)
- ECS (70)
- GA4 (74)
- GAE (20)
- GAS (28)
- GCP (530)
- GIS (18)
- GPS (17)
- GPU (11)
- Google Apps Script (19)
- HR (150)
- IBM (29)
- IDE (13)
- IPA (33)
- IT (41)
- IoT (76)
- JS (44)
- Jenkins (15)
- Jupyter (13)
- Kinect (11)
- Kubernetes (21)
- LDAP (30)
- LINE (41)
- LLM (120)
- Looker (16)
- LookerStudio (23)
- MS (15)
- MacBook (13)
- Mojolicious (18)
- MySQL (76)
- NAT (15)
- NAVER (35)
- NewRelic (15)
- NoCode (18)
- OS (13)
- R (12)
- RPA (27)
- RSS (35)
- Redmine (29)
- RetailAPI (14)
- SL (14)
- SORACOM (36)
- SSL (54)
- SaaS (33)
- TV (16)
- TensorFlow (29)
- Terraform (71)
- TypeScript (13)
- UI8 (22)
- USB (11)
- UX (25)
- Unity (37)
- VPC (25)
- VPN (25)
- VR (37)
- VertexAI (28)
- Vue.js (11)
- Webｻｰﾋﾞｽ (11)
- Workflows (13)
- XML (26)
- Yahoo! (12)
- Zabbix (37)
- actionscript (18)
- ad (29)
- adobe (15)
- agile (16)
- ai (409)
- ajax (32)
- algorithm (52)
- amazon (34)
- analysis (15)
- analytics (13)
- android (170)
- animation (56)
- anime (14)
- ansible (36)
- apache (73)
- apex (26)
- api (349)
- app (15)
- apple (18)
- application (31)
- architecture (123)
- arduino (21)
- art (56)
- authentication (14)
- aws (804)
- backup (12)
- bash (37)
- bigquery (325)
- blog (80)
- bluetooth (11)
- book (61)
- books (24)
- bootstrap (16)
- bot (26)
- browser (25)
- business (155)
- c# (26)
- capistrano (14)
- career (31)
- catalyst (21)
- centos (28)
- centos7 (19)
- chart (19)
- cheatsheet (26)
- china (12)
- chrome (53)
- ci (21)
- cloud (16)
- cloudformation (13)
- cms (18)
- code (30)
- cognito (14)
- color (15)
- column (36)
- comic (26)
- command (27)
- communication (20)
- community (24)
- company (19)
- computer (33)
- cooking (13)
- cpan (22)
- cpu (11)
- css (94)
- culture (12)
- curl (14)
- data (46)
- database (78)
- dbt (18)
- debug (16)
- deploy (18)
- design (159)
- desktop (13)
- development (158)
- device (14)
- dns (25)
- docker (157)
- document (57)
- download (14)
- dynamodb (23)
- ec2 (52)
- eclipse (12)
- economy (15)
- editor (32)
- education (60)
- elasticsearch (17)
- elb (16)
- engineer (16)
- english (45)
- event (68)
- excel (46)
- extension (50)
- facebook (38)
- fargate (31)
- fashion (19)
- finance (17)
- firebase (47)
- firefox (67)
- flash (109)
- fluentd (35)
- font (17)
- food (22)
- framework (56)
- free (20)
- future (14)
- gadget (45)
- game (130)
- gears (17)
- generator (75)
- gif (15)
- gigazine (15)
- git (65)
- github (72)
- golang (93)
- google (370)
- google analytics (38)
- googlegears (17)
- graph (19)
- graphics (15)
- greasemonkey (13)
- hardware (34)
- hatena (41)
- history (48)
- hotel (12)
- howto (29)
- html (32)
- html5 (24)
- http (15)
- hubot (16)
- iOS (79)
- iPad (24)
- iam (52)
- icon (31)
- idea (14)
- image (27)
- infra (22)
- infrastructure (34)
- interface (25)
- internet (17)
- interview (35)
- iphone (147)
- itamae (18)
- item (20)
- jQuery (23)
- japan (22)
- japanese (16)
- java (77)
- javascript (225)
- json (17)
- kaggle (22)
- knowledge (14)
- lambda (39)
- language (23)
- laravel (17)
- learning (23)
- lecture (13)
- lesson (17)
- library (110)
- life (48)
- lifehack (31)
- lifehacks (15)
- linux (264)
- log (32)
- logstash (23)
- mac (135)
- machine learning (104)
- machinelearning (21)
- magazine (11)
- mail (39)
- make (20)
- management (32)
- map (41)
- markdown (19)
- marketing (36)
- mashup (19)
- mathematics (12)
- media (23)
- microsoft (44)
- mixi (11)
- mobile (112)
- module (13)
- money (19)
- mongodb (15)
- monitoring (24)
- movie (71)
- mp3 (12)
- music (92)
- network (141)
- news (58)
- nginx (27)
- node.js (99)
- office (15)
- online (11)
- opensource (13)
- openssl (20)
- oss (19)
- p2p (13)
- payment (19)
- paypal (11)
- pc (12)
- pdf (31)
- performance (98)
- perl (316)
- pgpool (15)
- photo (27)
- php (156)
- plagger (21)
- plugin (102)
- podcast (19)
- postgresql (101)
- presentation (86)
- processing (81)
- programming (270)
- project (17)
- prometheus (15)
- proxy (17)
- python (182)
- rails (22)
- rds (18)
- react (25)
- reference (131)
- research (68)
- ruby (101)
- s3 (37)
- salesforce (136)
- sample (21)
- schalor (15)
- science (57)
- scraping (19)
- search (87)
- security (239)
- seo (31)
- server (79)
- serverless (29)
- shell (22)
- sketch (37)
- slack (106)
- slideshare (15)
- sns (55)
- social (11)
- society (12)
- software (147)
- sound (27)
- sql (67)
- sqlite (20)
- ssh (27)
- startup (84)
- statistics (35)
- storage (21)
- study (38)
- swift (27)
- systemd (11)
- technology (83)
- template (68)
- test (96)
- tips (123)
- tmux (15)
- tool (51)
- tools (65)
- translation (15)
- travel (41)
- tutorial (166)
- tutorials (16)
- twitter (50)
- ubuntu (23)
- ui (50)
- vagrant (17)
- venture (14)
- video (35)
- vim (38)
- visualization (70)
- vmware (14)
- web (56)
- webdesign (32)
- webservice (33)
- webサービス (65)
- wii (12)
- wiki (17)
- wikipedia (121)
- windows (118)
- wordpress (121)
- work (35)
- youtube (68)
- あとで読む (13)
- お役立ち (18)
- これはすごい (19)
- まとめ (141)
- ネタ (32)
- 不動産 (30)
- 仕事 (16)
- 写真 (13)
- 動画 (49)
- 壁紙 (14)
- 家具 (14)
- 広告 (23)
- 技術 (29)
- 投資 (43)
- 教育 (12)
- 検索 (33)
- 機械学習 (12)
- 歴史 (19)
- 海外 (20)
- 画像 (42)
- 研究 (20)
- 社会 (37)
- 科学 (13)
- 素材 (35)
- 経済 (28)
- 統計 (25)
- 考察 (22)
- 記事 (36)
- 設計 (15)
- 読み物 (15)
- 資料 (127)
- 資格 (40)
- 起業 (59)
- 開発 (16)
- 雑学 (13)
- 電子工作 (15)
- 音楽 (16)
- *business (1094)
- aws (804)
- *development (729)
- GCP (530)
- *まとめ (493)
- *お役立ち (476)
- *webサービス (428)
- ai (409)
- *marketing (401)
- *company (384)
tutorialとpgpoolに関するmichael-unltdのブックマーク (1)
-
michael-unltd 2017/03/15
コードでpgpoolの設定するパターン- postgresql
- pgpool
- tutorial
リンク -
1
公式Twitter
- @HatenaBookmark
リリース、障害情報などのサービスのお知らせ
- @hatebu
最新の人気エントリーの配信
処理を実行中です
キーボードショートカット一覧
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
設定を変更しましたx