Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Zkp8h-0003R2-8K for pgsql-admin@arkaria.postgresql.org; Sat, 10 Oct 2015 08:04:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1Zkp8g-0000SI-25 for pgsql-admin@arkaria.postgresql.org; Sat, 10 Oct 2015 08:04:22 +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 1Zkp8e-0000Rz-AN for pgsql-admin@postgresql.org; Sat, 10 Oct 2015 08:04:20 +0000 Received: from [59.151.11.101] (helo=Exchange02.qunarservers.com) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1Zkp8X-0005D7-RC for pgsql-admin@postgresql.org; Sat, 10 Oct 2015 08:04:18 +0000 Received: from Exchange10.qunarservers.com (119.254.26.7) by EXCHANGE02.qunarservers.com (59.151.11.104) with Microsoft SMTP Server (TLS) id 14.3.123.3; Sat, 10 Oct 2015 16:03:48 +0800 Received: from [192.168.168.211] (192.168.168.211) by Exchange10.qunarservers.com (192.168.39.94) with Microsoft SMTP Server (TLS) id 14.3.123.3; Sat, 10 Oct 2015 16:03:48 +0800 Message-ID: <5618C644.8010809@qunar.com> Date: Sat, 10 Oct 2015 16:03:16 +0800 From: =?UTF-8?B?5byg5paH5Y2H?= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.7.0 MIME-Version: 1.0 To: Nikolay Popov , Subject: Re: Pacemaker dynamic membership References: <5614CD4A.7020900@postgrespro.ru> In-Reply-To: <5614CD4A.7020900@postgrespro.ru> Content-Type: multipart/alternative; boundary="------------010004020609040607060607" X-Host-Lookup-Failed: Reverse DNS lookup failed for 59.151.11.101 (deferred) X-Pg-Spam-Score: -1.1 (-) 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 --------------010004020609040607060607 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit 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 --------------010004020609040607060607 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 8bit 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

--------------010004020609040607060607--