Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZlXzo-0002EV-7u for pgsql-admin@arkaria.postgresql.org; Mon, 12 Oct 2015 07:58:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZlXzn-0001Fn-KL for pgsql-admin@arkaria.postgresql.org; Mon, 12 Oct 2015 07:58:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZlXy6-0007pK-Mh for pgsql-admin@postgresql.org; Mon, 12 Oct 2015 07:56:26 +0000 Received: from newmail.postgrespro.ru ([93.174.131.138] helo=mail.postgrespro.ru) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1ZlXy1-0002g1-NU for pgsql-admin@postgresql.org; Mon, 12 Oct 2015 07:56:26 +0000 Received: from [127.0.0.1] (unknown [192.168.27.1]) by mail.postgrespro.ru (Postfix) with ESMTPSA id 5EACE21C243D; Mon, 12 Oct 2015 10:56:20 +0300 (MSK) Subject: Re: Pacemaker dynamic membership To: =?UTF-8?B?5byg5paH5Y2H?= , pgsql-admin@postgresql.org References: <5614CD4A.7020900@postgrespro.ru> <5618C644.8010809@qunar.com> From: Nikolay Popov Message-ID: <561B6799.2040300@postgrespro.ru> Date: Mon, 12 Oct 2015 10:56:09 +0300 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 In-Reply-To: <5618C644.8010809@qunar.com> Content-Type: multipart/alternative; boundary="------------060508070706060901040709" X-Antivirus: avast! (VPS 151011-0, 10/11/2015), Outbound message X-Antivirus-Status: Clean X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org This is a multi-part message in MIME format. --------------060508070706060901040709 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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@postgrespro.ru Postgres Professional: http://www.postgrespro.com The Russian Postgres Company --------------060508070706060901040709 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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@postgrespro.ru
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--------------060508070706060901040709--