Re: Pacemaker dynamic membership

张文升 <wensheng.zhang@xxxxxxxxx> · Sat, 10 Oct 2015 16:03:16 +0800



    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