大渕ã•ã‚“
ã“ã‚“ã«ã¡ã¯ã€å±±å†…ã§ã™ã€‚
å ´åˆã«ã‚ˆã£ã¦ã¯ã€monitorã®ã‚¿ã‚¤ãƒ アウトã®ä¼¸é•·ã¯æœ‰åŠ¹ã ã¨æ€ã„ã¾ã™ã€‚
ãŸã ã—ã€è² è·è©¦é¨“ãªã©ã§ã€å®Ÿéš›ã«ã‹ã‹ã‚‹è² è·ã‚’ã‚る程度見極ã‚ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚
ã¾ãŸã€ä»®æƒ³ãƒžã‚·ãƒ³ã§æ§‹æˆã•ã‚Œã¦ã„ã‚‹å ´åˆãªã©ã¯ã€CPUãªã©ã«åˆ¶é™ã‚’ã‹ã‘ã¦ã„ã‚‹å ´åˆã¯ã€ãã®åˆ¶é™ã‚’増やã™ãªã©ã‚‚
有効ãªå ´åˆãŒã‚ã‚Šã¾ã™ã€‚
以上ã§ã™ã€‚
----- Original Message -----
>From: 大渕æ˜å¤« <ohbuchi@m2j.co.jp>
>To: linux-ha-japan@lists.osdn.me
>Date: 2015/10/2, Fri 10:40
>Subject: Re: [Linux-ha-jp] PostgreSQLã®ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—リケーションã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã®åŽŸå› ã«ã¤ã„ã¦
>
>
>度々ã™ã„ã¾ã›ã‚“。
>大渕ã§ã™ã€‚
>
>昨日ã®å•ã„åˆã‚ã›å†…容ãªã‚“ã§ã™ãŒã€CRMã®è¨å®šã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚
>
>primitive pgsql ocf:heartbeat:pgsql \
>Â Â Â params pgctl="/usr/local/pgsql-9.2.4/bin/pg_ctl"
      psql="/usr/local/pgsql-9.2.4/bin/psql"
      pgdata="/var/lib/pgsql/data/" start_opt="-p 5432" rep_mode="sync"
      node_list="ptdb01.localdomain ptdb02.localdomain"
      restore_command="cp /var/lib/pgsql/data/pg_archive/%f %p"
      primary_conninfo_opt="keepalives_idle=60 keepalives_interval=5
      keepalives_count=5" master_ip="172.16.1.3" stop_escalate="0" \
>Â Â Â op start interval="0s" timeout="60s" on-fail="restart" \
>Â Â Â op monitor interval="7s" timeout="60s" on-fail="restart" \
>Â Â Â op monitor interval="2s" role="Master" timeout="60s"
      on-fail="restart" \
>Â Â Â op promote interval="0s" timeout="60s" on-fail="restart" \
>Â Â Â op demote interval="0s" timeout="60s" on-fail="stop" \
>Â Â Â op stop interval="0s" timeout="60s" on-fail="block" \
>Â Â Â op notify interval="0s" timeout="60s"
>
>16:15ã®æ™‚点ã§ã¯ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼å¾Œãªã®ã§ç‰‡è‚ºçŠ¶æ…‹ã ã£ãŸã¨æ€ã†ã®ã§ã™ãŒã€ãã®æ™‚ã«é‡ã„クエリãŒå®Ÿè¡Œã•ã‚Œã¦åœæ¢å‡¦ç†ã®ã‚¿ã‚¤ãƒ アウト値
      60sã«åˆ°é”ã—ãŸã®ã§è‡ªãƒŽãƒ¼ãƒ‰ã®postgresプãƒã‚»ã‚¹ã‚’強制終了ã—ãŸã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã§ã—ょã†ã‹ã€‚
>
>片肺状態ã§ã‚‚タイムアウト値ã«åˆ°é”ã™ã‚‹ã¨postgresプãƒã‚»ã‚¹ã®å¼·åˆ¶çµ‚了を実行ã—ã¦ã—ã¾ã†ã®ã§ã—ょã†ã‹ã€‚
>
>ãã®å ´åˆã“ã®è¨å®šã®60sã‚’300sãªã©ã«ä¿®æ£ã™ã‚‹ã¨é‡ã„クエリã«è€ãˆã‚‰ã‚Œã‚‹çŠ¶æ…‹ã«ãªã‚Šã¾ã™ã§ã—ょã†ã‹ã€‚
>
>ã„ã¾ã•ã‚‰ãªè³ªå•ã§æ縮ã§ã™ãŒã€ãŠæ™‚é–“ã‚ã‚‹ã¨ãã«ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã„ãŸã ã‘ã¾ã™ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚
>
>以上ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
>
>On 2015/10/01 19:25, 大渕æ˜å¤« wrote:
>
>å„ä½
>>
>>ãŠä¸–話ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚
>>大渕ã¨ç”³ã—ã¾ã™ã€‚
>>
>>å‰å›žã“ã¡ã‚‰ã§å•ã„åˆã‚ã›ã•ã›ã¦ã‚‚らã£ãŸã‚µãƒ¼ãƒãƒ¼ã«ã¤ã„ã¦ã€ã¾ãŸè³ªå•ã•ã›ã¦ãã ã•ã„。
>>
>>「PostgreSQL9.1ストリーミングレプリケーション対応リソースエー ジェント〠をå‚考ã«æ§‹ç¯‰ã—ãŸã‚µãƒ¼ãƒãƒ¼ã§ã™ã€‚
>>
>>環境ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚
>>CentOS5
>>PostgreSQL9.2.4
>>Pacemaker1.0.13-1.1
>>Master/Slave構æˆ
>>以上
>>
>>å‰å›žã€æ¾å³¶ã•ã‚“ã«ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã„ãŸã ã„ãŸå†…容をå‚考ã«ã€PostgreSQLã® max_connectionsã®100ã‚’1000ã«ä¸Šã’ã¦
      work_memã‚’32MBã‹ã‚‰4MBã«ä¸‹ã’ã¦ã‹ã‚‰ãƒ‡ãƒ¼ ã‚¿åŒæœŸã—ã¦HA構æˆã«æˆ»ã—ãŸã®ã§ã™ãŒã€æœ¬æ—¥ä»¥ä¸‹ã®ã‚ˆã†ãªäº‹è±¡ãŒç™ºç”Ÿã—ã¾ã—ãŸã€‚
>>
>>14:08 エラーãŒãƒžã‚¹ã‚¿ãƒ¼æ©Ÿã§ç™ºç”Ÿã€PostgreSQLåœæ¢/フェイルオーãƒãƒ¼ç™ºç”Ÿ
>>16:15 エラーãŒãƒžã‚¹ã‚¿ãƒ¼æ©Ÿã§ç™ºç”Ÿã€PostgreSQLåœæ¢ã€€DBアクセスä¸å¯ã¨ãƒ¦ãƒ¼ ザーã‹ã‚‰é€£çµ¡
>>16:15 サーãƒãƒ¼ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸã¨ã“ã‚以下ã®çŠ¶æ…‹
>>
>>Node Attributes:
>>* Node ptdb01.localdomain:
>>   + default_ping_set                 : 100
>>Â Â Â + master-pgsql:1Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â : -INFINITY
>>   + pgsql-data-status                : LATEST
>>   + pgsql-status                     : STOP
>>Â Â Â + ptdb02.localdomain-eth2Â Â Â Â Â Â Â Â Â Â : up
>>Â Â Â + ptdb02.localdomain-eth3Â Â Â Â Â Â Â Â Â Â : up
>>* Node ptdb02.localdomain:
>>   + default_ping_set                 : 100
>>Â Â Â + master-pgsql:0Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â : -INFINITY
>>   + pgsql-data-status                : DISCONNECT
>>   + pgsql-status                     : STOP
>>Â Â Â + ptdb01.localdomain-eth2Â Â Â Â Â Â Â Â Â Â : up
>>Â Â Â + ptdb01.localdomain-eth3Â Â Â Â Â Â Â Â Â Â : up
>>
>>Failed actions:
>>Â Â Â pgsql:0_monitor_2000 (node=ptdb02.localdomain, call=16, rc=-2,
      status=Timed Out): unknown exec error
>>Â Â Â pgsql:1_monitor_2000 (node=ptdb01.localdomain, call=22, rc=-2,
      status=Timed Out): unknown exec error
>>
>>16:25 両ノードをåœæ¢ã€ãƒžã‚¹ã‚¿ãƒ¼æ©Ÿã®ã¿ã§èµ·å‹•ã—ã¦å–り急ãŽå¾©æ—§
>>以上
>>
>>14:08ã¨16:15ã«é‡ã„クエリを実行ã—ãŸãã†ãªã®ã§ã€work_memã‚’4MBã«ä¸‹ã’ãŸãŸã‚ ã«PostgreSQLã«å•é¡ŒãŒèµ·ãã¦
      unknown exec errorã«ãªã£ãŸã®ã§ã¯ãªã„ã‹ã¨æ€ã£ ã¦ã„ã¾ã™ã€‚
>>
>>ha-logを添付ã•ã›ã¦ã„ãŸã ãã¾ã™ã®ã§ã€æœ¬ä»¶ã®åŽŸå› ã¨ä»Šå¾Œã®å†ç™ºé˜²æ¢ç–ã«ã¤ã„ ã¦ã€ã”教示ã„ãŸã ã‘ã‚‹ã¨å¤§å¤‰ã‚ã‚ŠãŒãŸã„ã§ã™ã€‚
>>
>>以上ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
>>
>>On 2015/08/26 11:45, Takehiro Matsushima wrote:
>>
>>大渕ã•ã‚“
>>>
>>>æ¾å³¶ã§ã™ã€‚
>>>OSC 2015 Tokyo/Fallã§ãŠä¼šã„ã§ãã‚‹ã“ã¨ã‚’楽ã—ã¿ã«ã—ã¦ãŠã‚Šã¾ã™ï¼
>>>
>>>
>>>Webサーãƒãƒ¼(æ£ç¢ºã«ã¯APサーãƒãƒ¼)ãŒDBã«å¯¾ã—ã¦ã„ãã¤ã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’張るã‹ã¨ã„ã†ã“ã¨ã‚’本当ã¯è¨ˆç®—ã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚
>>>APã‚ãŸã‚Šã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°ã€APå°æ•°ã€å†…部的ã«ç”Ÿã˜ã‚‹ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°ã€é€šå¸¸ç®¡ç†ç”¨ã«å¿…è¦ãªã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°ã€DBã®ãƒªã‚½ãƒ¼ã‚¹ã€APã®ãƒª
        ソースãªã©ã‹ã‚‰å€¤ã‚’決ã‚ã¦ã„ãã“ã¨ã«ãªã‚‹ã¨ãŠã‚‚ã„ã¾ã™ã€‚
>>>
>>>pg_isreadyã§ã™ãŒã€ç¾çŠ¶ã®pgsql RAã¯æœªå¯¾å¿œã§ã™ã®ã§ã€RAを改修ã—ã¦ã¿ã‚‹ã®ã‚‚楽ã—ã„ã¨æ€ã„ã¾ã™ã€‚
>>>
>>>フェイルオーãƒãƒ¼ã®æ¤œçŸ¥ã§ã™ãŒã€ç§ã¯MailTo RAを使用ã—ã¦ãƒ¡ãƒ¼ãƒ«é€šçŸ¥ã‚’ã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚
>>>Zabbixç‰ã®ç›£è¦–ソリューションã§ãƒ—ãƒã‚»ã‚¹ç›£è¦–ã—ãŸã‚Šã‚«ã‚¹ã‚¿ãƒ コマンドã§ç›£è¦–ã—ãŸã‚Šã€ã‚‚ã—ãã¯SNMPを使用ã™ã‚‹ã®ã‚‚よã„ã¨æ€ã„ã¾
        ã™ã€‚
>>>時間的ã«ä½™è£•ãŒã‚ã‚‹ã®ã§ã—ãŸã‚‰ã„ã‚ã„ã‚試ã—ã¦ã¿ã¦ã€æœ€çµ‚çš„ã«æ±ºå®šã—ã¦ã„ãŸã ãã®ãŒã‚‚ã¡ã‚ん最善ã ã¨ã¯æ€ã„ã¾ã™ãŒã€å³å¸ã§ã¨ã„ã†ã“ã¨ã§ã—ãŸ
        らã¨ã‚Šã‚ãˆãšMailTo
>>>RAãŒä½¿ã„ã‚„ã™ã„å°è±¡ã§ã™ã€‚
>>>ãœã²ãŠè©¦ã—ãã ã•ã„。
>>>
>>>以上よã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
>>>
>>>----
>>>Takehiro Matsushima
>>>
>>>2015å¹´8月26æ—¥ 10:32 大渕æ˜å¤« <ohbuchi@m2j.co.jp>:
>>>
>>>æ¾å³¶ã•ã‚“
>>>>
>>>>ãŠä¸–話ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚
>>>>大渕ã§ã™ã€‚
>>>>
>>>>ã”無沙汰ã—ã¦ã¾ã™ï¼
>>>>ã¾ãŸæ¬¡å›žã®OSCã«éŠã³ã«è¡Œã“ã†ã‹ã¨æ€ã£ã¦ã¾ã™ã€‚
>>>>
>>>>早速ã®è¿”ä¿¡ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚
>>>>大変助ã‹ã‚Šã¾ã™ã€‚
>>>>
>>>>max_connectionsã®è¨å®šãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®100ã ã£ãŸã®ãŒå•é¡Œã ã£ãŸã‚“ã§ã™ã。
>>>>WEBサーãƒãƒ¼å´ã®è¨å®šã¨DBå´ã®è¨å®šã«ç›¸é•ãŒã‚ã£ãŸã‚ˆã†ãªã®ã§ã€ä»Šå›žã¯
>>>>max_connectionsã‚’é©åˆ‡ãªæ•°å€¤ã«åˆã‚ã›ã‚‹æ–¹å‘ã§å¯¾å‡¦ã— よã†ã¨æ€ã„ã¾ã™ã€‚
>>>>ã¡ãªã¿ã«superuser_reserved_connectionsã¯ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆã•ã‚Œã¦ã„ã¾ã—ãŸã€‚
>>>>
>>>>今使ã£ã¦ã„るサーãƒãƒ¼è‡ªä½“ãŒæ¥å¹´ã‚ãŸã‚Šã«ã¯ãƒªãƒ—レイスã«ãªã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã®
>>>>ã§ã€ãã®éš›ã«ã¯pg_isreadyも調ã¹ã¦ã¿ã‚ˆã†ã‹ã¨æ€ã„ã¾ ã™ã€‚
>>>>
>>>>ã¨ã“ã‚ã§ã€ä»Šå›žãŸã¾ãŸã¾ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã—ã¦ã„ãŸã“ã¨ã«æ°—ã¥ã„ãŸã®ã§ã™ãŒã€ã¿
>>>>ãªã•ã‚“ã¯ã©ã®ã‚ˆã†ã«ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã‚’検知ã—ã¦ã„ã‚‹ã®ã§ã—ょㆠã‹ã€‚
>>>>
>>>>以上ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
>>>>
>>>>On 2015/08/26 2:17, Takehiro Matsushima wrote:
>>>>
>>>>大渕ã•ã‚“
>>>>>
>>>>>ãŠä¸–話ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€æ¾å³¶ã§ã™ã€‚
>>>>>ã”無沙汰ã—ã¦ãŠã‚Šã¾ã™ã€‚
>>>>>
>>>>>PostgreSQLã®ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ¬ãƒ—リケーションã«ãŠã„ã¦ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã¯ãƒžã‚¹ã‚¿ãƒ¼ã«å¯¾ã—ã¦å¸¸æ™‚接続を行ã£ã¦ã„ãŸã¨æ€ã„ã¾ã™ã®
            ã§ã€max_connectionsを使ã„切ã£ãŸçŠ¶æ…‹ã§ãƒ¬ãƒ—リケーションを新è¦ã«é–‹å§‹ã—よã†ã¨ã—ãŸã®ã§ãªã‘ã‚Œã°ã€å•é¡Œãªã„ã¯ãšã§
            ã™ã€‚
>>>>>max_wal_senders :
>>>>>https://www.postgresql.jp/document/9.2/html/runtime-config-replication.html
>>>>>max_connections ãŠã‚ˆã³ superuser_reserved_connections :
>>>>>https://www.postgresql.jp/document/9.2/html/runtime-config-connection.html
>>>>>
>>>>>ãƒã‚°ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‹ã‚‰ã¯RAãŒæ»æ´»ç›£è¦–ã®ãŸã‚ã«PostgreSQLã«æŽ¥ç¶šã—よã†ã¨ã—ã¦æ‹’å¦ã•ã‚Œã¦ã„ã‚‹ã¨ç§ã¯æŽ¨æ¸¬ã—ã¾ã—ãŸã€‚
>>>>>RAã¯monitorアクションã§psqlã§æŽ¥ç¶šã—ã€SQL(デフォルト㯠SELECT now()
            )を実行ã—ã¦æˆå¦ã‚’判æ–ã—ã¦ã„ã¾ã™ã€‚
>>>>>ã—ãŸãŒã£ã¦ã€max_connectionsを使ã„切ã£ã¦ã„ã‚‹ã¨ãã«æ»æ´»ç›£è¦–ãŒèµ°ã‚‹ã¨ã€"Connection error
            (connection
>>>>>to the server went bad and the session was not interactive)
            occurred
>>>>>while executing the psql command."ã¨è¨€ã‚ã‚Œã¦ã—ã¾ã†ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚
>>>>>
>>>>>ã¨ã“ã‚ã§ã€ã“ã®çŠ¶æ³ã§ã‚ã£ã¦ã‚‚superuser_reserved_connectionsã§äºˆç´„ã—ã¦ã‚ã‚Œã°ã€
            monitor_userã«ã‚¹ãƒ¼ãƒ‘ーユーザーã®åå‰ã‚’書ã„ã¦ãŠãã“ã¨ã§æ»æ´»ç›£è¦–ã¯æˆåŠŸã™ã‚‹ã‚‚ã®ã¨æ€ã‚ã‚Œã¾ã™ã€‚
>>>>>管ç†ä½œæ¥ã®éƒ½åˆã‚‚ã‚ã‚Šã¾ã™ã®ã§superuser_reserved_connectionsã¯2以上必è¦ã§ã™ãŒã€é‹ç”¨ã‚„管ç†ã«
            åˆã‚ã›ã¦æœ€çµ‚çš„ãªæ•°ã‚’決定ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚
>>>>>ãŸã ã—ã€ã‚¹ãƒ¼ãƒ‘ーユーザー(postgresユーザãªã©)ã‚’æ»æ´»ç›£è¦–ç‰ã§ä½¿ç”¨ã™ã‚‹å ´åˆã«ã¯pg_hba.confãªã©ã‚’é©åˆ‡ã«è¨
            定ã—ãªãã¦ã¯ãªã‚Šã¾ã›ã‚“ã®ã§ã”注æ„ãã ã•ã„。
>>>>>
>>>>>余談ã§ã™ãŒPostgreSQL
            9.3ã‹ã‚‰ã¯æŽ¥ç¶šã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚’判別ã§ãã‚‹pg_isreadyã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãŒä½¿ãˆã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚
>>>>>https://www.postgresql.jp/document/9.3/html/app-pg-isready.html
>>>>>試ã—ã¦ã¿ã¦ã¯ã„ãªã„ã®ã§ã™ãŒã€monitorアクションã§ã“れも使ãˆã‚‹ã‚ˆã†ã«RAを変更ã™ã‚Œã°ã“ã†ã„ã£ãŸäº‹ä¾‹ã«ã‚‚対応ã§ãã‚‹ã‹ã‚‚
            ã—ã‚Œã¾ã›ã‚“。
>>>>>
>>>>>----
>>>>>Takehiro Matsushima
>>>>>
>>>>>
>>>>>
>>>>>2015å¹´8月25æ—¥ 18:50 大渕æ˜å¤« <ohbuchi@m2j.co.jp>:
>>>>>
>>>>>å„ä½
>>>>>>
>>>>>>ãŠä¸–話ã«ãªã£ã¦ãŠã‚Šã¾ã™ã€‚
>>>>>>大渕ã¨ç”³ã—ã¾ã™ã€‚
>>>>>>
>>>>>>2å¹´ã»ã©å‰ã«ã€ŒPostgreSQL9.1ストリーミングレプリケーション対応リソースエー
              ジェントã€ã‚’å‚考ã«æ§‹ç¯‰ã—ã€ã‚µãƒ¼ãƒãƒ¼ã®è¨ç½®å ´æ‰€ã®ç§»å‹•
>>>>>>ã®éš›ãªã©ä½•åº¦ã‹ã“ã¡ã‚‰ ã®ãƒ¡ãƒ¼ãƒªãƒ³ã‚°ãƒªã‚¹ãƒˆã«ãŠä¸–話ã«ãªã‚Šã¾ã—ã¦ã€ãŠã‹ã’ã•ã¾ã§ç„¡äº‹ã«ç¨¼åƒã—ã¦ã„ãŸã®
              ã§ã™ãŒã€æ˜¨å¤œã‚¢ã‚¯ã‚»ã‚¹ãŒé›†ä¸ã™ã‚‹äº‹æ…‹ãŒç™ºç”Ÿã—ãŸ
>>>>>>ã¨ã“ã‚ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã— ãŸã‚ˆã†ã§ã™ã€‚
>>>>>>
>>>>>>フェイルオーãƒãƒ¼ã—ãŸåŽŸå› ã‚’æ•™ãˆã¦ã„ãŸã ããŸãã€ãƒ¡ãƒ¼ãƒ«ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚
>>>>>>
>>>>>>ha-logを添付ã„ãŸã—ã¾ã™ã®ã§ã€ãŠåŠ›ã‚’貸ã—ã¦ã„ãŸã ã‘ã‚‹ã¨å¤§å¤‰ã‚ã‚ŠãŒãŸã„ã§ã™ã€‚
>>>>>>
>>>>>>環境ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚
>>>>>>CentOS5
>>>>>>PostgreSQL9.2.4
>>>>>>Pacemaker1.0.13-1.1
>>>>>>Master/Slave構æˆ
>>>>>>以上
>>>>>>
>>>>>>ã¾ãŸã€ha-logã®7028行目ã‚ãŸã‚Šã«ä»¥ä¸‹ã®ã‚ˆã†ãªè¡¨ç¤ºãŒã‚ã‚Šã¾ã—ãŸã®ã§ã€ã“ã®æ™‚é–“
              ã«errorãŒç™ºç”Ÿã—ãŸã“ã¨ãŒåŽŸå› ã§ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã™ã‚‹
>>>>>>æµã‚Œã«ãªã£ãŸã‚ˆã†ã«æ€ã‚ ã‚Œã¾ã™ã€‚
>>>>>>
>>>>>>Aug 24 22:15:37 ptdb01.localdomain lrmd: [7455]: info: RA
              output:
>>>>>>(pgsql:0:monitor:stderr) psql: FATAL:Â sorry, too many
              clients already
>>>>>>pgsql(pgsql:0)[21016]: 2015/08/24_22:15:37 ERROR:
              PostgreSQL template1 isn't
>>>>>>running
>>>>>>pgsql(pgsql:0)[21016]: 2015/08/24_22:15:37 ERROR:
              Connection error
>>>>>>(connection to the server went bad and the session was not
              interactive)
>>>>>>occurred while executing the psql command.
>>>>>>Aug 24 22:15:37 ptdb01.localdomain crmd: [7458]: info:
              process_lrm_event:
>>>>>>LRM operation pgsql:0_monitor_2000 (call=16, rc=1,
              cib-update=50710,
>>>>>>confirmed=false) unknown error
>>>>>>以上
>>>>>>
>>>>>>Masterå´ã®ã‚µãƒ¼ãƒãƒ¼è‡ªä½“ã¯ãƒ€ã‚¦ãƒ³ã—ã¦ãŠã‚Šã¾ã›ã‚“。/var/log/messagesã®è©²å½“時
              刻ã«ã¯ç‰¹ã«ãƒã‚°ã¯ãªã‹ã£ãŸã®ã§å•é¡Œãªãå‹•ã„ã¦
>>>>>>ã„るよã†ã«æ€ã‚ã‚Œã¾ã™ã€‚
>>>>>>
>>>>>>アクセスãŒé•·æ™‚間集ä¸ã—ãŸã®ã§Masterå´ã®PostgreSQLã®è¨å®šã«ã‚ã£ãŸ
              max_connections=100ã®çŠ¶æ…‹ãŒç¶šã„ã¦ã—ã¾
>>>>>>ã„ã€Slaveå´ã®é€šä¿¡ã«å¿œç”ã—ãªã‹ã£ãŸ ãŸã‚フェイルオーãƒãƒ¼ã—ã¦ã—ã¾ã£ãŸã®ã§ã¯ãªã„ã‹ã¨äºˆæƒ³ã—ã¦ã¿ãŸã®ã§ã™ãŒã€ãã†
              ã„ã£ãŸã“ã¨ã¯è€ƒãˆã‚‰ã‚Œã¾ã™ã§ ã—ょã†ã‹ã€‚
>>>>>>
>>>>>>以上ã€ãŠå¿™ã—ã„ã¨ã“ã‚æ縮ã§ã™ãŒã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
>>>>>>
>>>>>>
>>>>>>_______________________________________________
>>>>>>Linux-ha-japan mailing list
>>>>>>Linux-ha-japan@lists.osdn.me
>>>>>>http://lists.osdn.me/mailman/listinfo/linux-ha-japan
>>>>>>
>>>>>>
_______________________________________________
>>>>>Linux-ha-japan mailing list
>>>>>Linux-ha-japan@lists.osdn.me
>>>>>http://lists.osdn.me/mailman/listinfo/linux-ha-japan
>>>>>
>>>>>
_______________________________________________
>>>>Linux-ha-japan mailing list
>>>>Linux-ha-japan@lists.osdn.me
>>>>http://lists.osdn.me/mailman/listinfo/linux-ha-japan
>>>>
_______________________________________________
>>>Linux-ha-japan mailing list
>>>Linux-ha-japan@lists.osdn.me
>>>http://lists.osdn.me/mailman/listinfo/linux-ha-japan
>>>
>>>
>>
>>
>>_______________________________________________
Linux-ha-japan mailing list Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan >_______________________________________________
>Linux-ha-japan mailing list
>Linux-ha-japan@lists.osdn.me
>http://lists.osdn.me/mailman/listinfo/linux-ha-japan
>
>
>
_______________________________________________
Linux-ha-japan mailing list
Linux-ha-japan@lists.osdn.me
http://lists.osdn.me/mailman/listinfo/linux-ha-japan