MLã®çš†æ§˜
ã¯ã˜ã‚ã¾ã—ã¦ã€æ›½æ ¹ã¨ç”³ã—ã¾ã™ã€‚
ã“ã®ãŸã³ã¯è¡¨é¡Œã®ä»¶ã«ã¤ã„ã¦ä¸Šæ‰‹ãè¡Œã‹ãªã„ãŸã‚ã€ã”相談ã«å‚ã‚Šã¾ã—ãŸã€‚
■環境
・OS
# cat /etc/redhat-release
CentOS release 6.6 (Final)
・Pacemakerç‰
# rpm -q corosync corosynclib cluster-glue cluster-glue-libs heartbeat
heartbeat-libs resource-agents pacemaker
pacemaker-libs pm_crmgen pm_diskd pm_extras pm_logconv-hb libesmtp ipmitool
corosync-1.4.7-1.el6.x86_64
corosynclib-1.4.7-1.el6.x86_64
cluster-glue-1.0.11-1.el6.x86_64
cluster-glue-libs-1.0.11-1.el6.x86_64
heartbeat-3.0.5-1.1.el6.x86_64
heartbeat-libs-3.0.5-1.1.el6.x86_64
resource-agents-3.9.5-12.el6_6.3.x86_64
pacemaker-1.0.13-2.el6.x86_64
pacemaker-libs-1.0.13-2.el6.x86_64
pm_crmgen-1.4-1.el6.noarch
pm_diskd-1.3-1.el6.x86_64
pm_extras-1.5-1.el6.x86_64
pm_logconv-hb-1.3-1.el6.noarch
libesmtp-1.0.4-16.el6.x86_64
ipmitool-1.8.11-21.el6.x86_64
・PostgreSQL
# rpm -qa | grep postgres
postgresql93-9.3.6-1PGDG.rhel6.x86_64
postgresql93-docs-9.3.6-1PGDG.rhel6.x86_64
postgresql93-libs-9.3.6-1PGDG.rhel6.x86_64
postgresql93-server-9.3.6-1PGDG.rhel6.x86_64
postgresql93-contrib-9.3.6-1PGDG.rhel6.x86_64
以上ã®ã¨ãŠã‚Šã§ã™ã€‚
ç¾è±¡ã¨ã—ã¦ã¯
スレーブå´ã®ãƒ¬ãƒ—リケーションãŒé–‹å§‹ã•ã‚Œãªã„
状態ã§ã™ã€‚
調査ã—ã¦ã¿ã‚‹ã¨PacemakerãŒä½œæˆã™ã‚‹
/var/lib/pgsql/tmp/rep_mode.conf
ã®ä¸èº«ãŒ
synchronous_standby_names = ''
ã¨ãªã£ã¦ãŠã‚Šã€ãã‚ŒãŒåŽŸå› ã‹ã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚
大変ãŠæ‰‹æ•°ã§ã™ãŒsynchronous_standby_namesã¯ã©ã®ãƒ‘ラメータを元ã«ä½œæˆã•ã‚Œã‚‹ã®ã§ã—ょã†ã‹ã€‚
ã¾ãŸãã®ä»–ã”æ示ã™ã¹ãæƒ…å ±ãŒå¿…è¦ã§ã—ãŸã‚‰ã”教示ã—ã¦ã„ãŸã ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚
以上ã®ã¨ãŠã‚Šã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚
ã¯ã˜ã‚ã¾ã—ã¦ã€æ›½æ ¹ã¨ç”³ã—ã¾ã™ã€‚
ã“ã®ãŸã³ã¯è¡¨é¡Œã®ä»¶ã«ã¤ã„ã¦ä¸Šæ‰‹ãè¡Œã‹ãªã„ãŸã‚ã€ã”相談ã«å‚ã‚Šã¾ã—ãŸã€‚
■環境
・OS
# cat /etc/redhat-release
CentOS release 6.6 (Final)
・Pacemakerç‰
# rpm -q corosync corosynclib cluster-glue cluster-glue-libs heartbeat
heartbeat-libs resource-agents pacemaker
pacemaker-libs pm_crmgen pm_diskd pm_extras pm_logconv-hb libesmtp ipmitool
corosync-1.4.7-1.el6.x86_64
corosynclib-1.4.7-1.el6.x86_64
cluster-glue-1.0.11-1.el6.x86_64
cluster-glue-libs-1.0.11-1.el6.x86_64
heartbeat-3.0.5-1.1.el6.x86_64
heartbeat-libs-3.0.5-1.1.el6.x86_64
resource-agents-3.9.5-12.el6_6.3.x86_64
pacemaker-1.0.13-2.el6.x86_64
pacemaker-libs-1.0.13-2.el6.x86_64
pm_crmgen-1.4-1.el6.noarch
pm_diskd-1.3-1.el6.x86_64
pm_extras-1.5-1.el6.x86_64
pm_logconv-hb-1.3-1.el6.noarch
libesmtp-1.0.4-16.el6.x86_64
ipmitool-1.8.11-21.el6.x86_64
・PostgreSQL
# rpm -qa | grep postgres
postgresql93-9.3.6-1PGDG.rhel6.x86_64
postgresql93-docs-9.3.6-1PGDG.rhel6.x86_64
postgresql93-libs-9.3.6-1PGDG.rhel6.x86_64
postgresql93-server-9.3.6-1PGDG.rhel6.x86_64
postgresql93-contrib-9.3.6-1PGDG.rhel6.x86_64
以上ã®ã¨ãŠã‚Šã§ã™ã€‚
ç¾è±¡ã¨ã—ã¦ã¯
スレーブå´ã®ãƒ¬ãƒ—リケーションãŒé–‹å§‹ã•ã‚Œãªã„
状態ã§ã™ã€‚
調査ã—ã¦ã¿ã‚‹ã¨PacemakerãŒä½œæˆã™ã‚‹
/var/lib/pgsql/tmp/rep_mode.conf
ã®ä¸èº«ãŒ
synchronous_standby_names = ''
ã¨ãªã£ã¦ãŠã‚Šã€ãã‚ŒãŒåŽŸå› ã‹ã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚
大変ãŠæ‰‹æ•°ã§ã™ãŒsynchronous_standby_namesã¯ã©ã®ãƒ‘ラメータを元ã«ä½œæˆã•ã‚Œã‚‹ã®ã§ã—ょã†ã‹ã€‚
ã¾ãŸãã®ä»–ã”æ示ã™ã¹ãæƒ…å ±ãŒå¿…è¦ã§ã—ãŸã‚‰ã”教示ã—ã¦ã„ãŸã ã‘ã‚‹ã¨å¹¸ã„ã§ã™ã€‚
以上ã®ã¨ãŠã‚Šã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚