Re: Pacemaker dynamic membership - Mailing list pgsql-admin

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

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@postgrespro.ru
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company