Home

Welcome to the resource-agents wiki @ t-matsuo!

I developed resource agents based on pgsql to support PostgreSQL Streaming Replication which is implemented on PostgreSQL 9.1 .

This function is merged so I don't maintain this repository.

Note

• The specification of Pacemaker 1.1.x is being changed dynamically so I recommend using Pacemaker 1.0.x .
• Need cluster-glue >= 1.0.9
  • 1.0.9 includes http://hg.linux-ha.org/glue/rev/29c2eb9fa966
• Need resource-agents >= 3.9.3 (recommend >= 3.9.5)

Docs

• Wiki (2nodes)
  • English
    • Outline, Features, Sample setting and so on
    • Operation examples for none shared wal archives environment
    • (NOT Recommended) Operation examples for shared wal archives environment
  • Japanese
    • Outline, Features, Sample setting and so on
  • [Other sample settings] (https://github.com/t-matsuo/resource-agents/wiki/Other-sample-settings-for-pgsql-RA-with-replication)

---

• External documents (English)
  • [PgSQL Replicated Cluster on Fedora 19 (Clusterlabs Wiki)] (http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster)
  • [PG Study 24th @ Tokyo] (http://www.postgresql.jp/wg/shikumi/shikumi24)
    • http://www.slideshare.net/takmatsuo/2012929-pg-study-16012253
  • linux.conf.au 2012 (English)
    • http://www.slideshare.net/ksk_ha/linuxconfauhaminiconfpgsql9120120116
      • Presenter Keisuke MORI (https://github.com/kskmori)
• External documents (Japanese)
  • [Fedora 19 上でPostgreSQL ストリーミングレプリケーションのクラスタリング] (http://linux-ha.sourceforge.jp/wp/archives/3680)
  • [OSC 2013 Tokyo/Spring] (https://www.ospn.jp/osc2013-spring/modules/eguide/event.php?eid=94)
    • http://www.slideshare.net/takmatsuo/osc-tokyospring2013-16694861
  • [PG Study 24th @ Tokyo] (http://www.postgresql.jp/wg/shikumi/shikumi24)
    • http://linux-ha.sourceforge.jp/wp/archives/3404
  • PostgreSQL Conference 2012
    • http://www.postgresql.jp/events/pgcon2012/program#A3
    • http://www.slideshare.net/MasaoFujii/20120224-forslideshare
  • [PG-REXプロジェクト(構築や運用ドキュメント等提供)] (http://sourceforge.jp/projects/pg-rex/releases/)

---

• Other web pages (English)
  • [Building a High-Availability PostgreSQL Cluster] (http://teamarin.net/wp-content/uploads/2014/01/Building-a-High-Availability-PostgreSQL-Cluster.pdf)
  • Postgresql 9.x High Availability (HA) with Pacemaker : [@SlideShare] (http://www.slideshare.net/nikhilsontakke/postgresql-9x-high-availability-ha-with-pacemaker) ,[@YouTube] (http://www.youtube.com/watch?v=pUsni8ak4oA)
  • [Scaling PostgreSQL at Braintree: Four Years of Evolution] (http://www.pgrs.net/2012/10/16/scaling-postgresql-at-braintree-four-years-of-evolution/)
  • [PostgreSQL 9.3: "One line – one slave"] (http://tl.reddit.com/r/programming/comments/16qzvm/postgresql_93_one_line_one_slave/c8150uo)
• Other web pages (Japanese)
  • [NTTグループにおけるOSS活用状況] (http://www.ntt.co.jp/svlab/activity/pickup/pdf/NTTgroup_OSS_Activities.pdf) p30
  • [PgDay 2012 Japan] (http://www.postgresql.jp/events/pgday2012_fall/)
  • [PostgreSQL レプリケーションの Q&A PostgreSQL Advent Calendar #8] (http://fujiimasao.blogspot.jp/2011/12/postgresql-q.html)
  • [PostgreSQLレプリケーション徹底紹介] (http://www.slideshare.net/MasaoFujii/postgresql-14799273)
  • http://d.hatena.ne.jp/smellman/20120105/1325711325
  • http://hayamiz.com/~haya/blog/?p=103

---

• Wiki (Old)
  • English for pg-rex branch (old stable)
  • Japanese for pg-rex branch (old stable)

---

• Wiki (cascade(4 nodes)) (under consideration) (my note)

  • English
    • Outline, Features, Sample setting and so on

• Wiki (for disaster site) (under consideration) (my note)

  • English
    • [Outline, Features, Sample setting and so on](https://github.com/t-matsuo/resource-agents/wiki/Resource-agent-for-postgresql-9.2-for-disaster(split\)-site)

• Wiki (for 3 nodes) (under consideration) (my note)

  • English
    • Outline, Features, Sample setting and so on