Re: Pacemaker dynamic membership

Nikolay Popov <n.popov@xxxxxxxxxxxxxx> · Mon, 12 Oct 2015 10:56:09 +0300



    Hi, Wensheng.

    
    Thanks for the advice.

    But it's not working.

    
    10.10.2015 11:03, 张文升 пишет:

    
      hi ：

      I also
          do not skilled, but can give you
        some advice. We can
          discuss.

      
      first：

      pcs resource update postgresql node_list="pi01 pi02 pi03........"

      
      then on pi05：

      1、stop pacemaker

      /etc/init.d/pacemaker stop

      
      2、find “PGSQL.lock” file and remove it，eg.,

      rm -f /tmp/PGSQL.lock
      rm -f /var/lib/pgsql/tmp/PGSQL.lock

        
      3、start corosync and pacemaker

      
      On 2015年10月07日 15:44, Nikolay Popov
        wrote:

      
        pgsql_start_0 on pi05
              'unknown error' (1): call=27, status=complete,
              exitreason='My data may be
         inconsistent. You have to
              remove /var/lib/pgsql/tmp/PGSQL.lock file to force
              start.',
            last-rc-change='Fri Oct
               2 17:04:10 2015', queued=0ms, exec=2553ms
      
      
      -- 
----------------------
张文升 | PostgreSQL DBA 
----------------------
pg开发指南 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=58058230
pg发布流程 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=56215301
pg值班列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=50508626
pg机器列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=36438672 
    
    
    -- 
Nikolay Popov
n.popov@xxxxxxxxxxxxxx
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company