Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZlgFc-0008QL-5z for pgsql-admin@arkaria.postgresql.org; Mon, 12 Oct 2015 16:47:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZlgFb-0007qQ-O3 for pgsql-admin@arkaria.postgresql.org; Mon, 12 Oct 2015 16:47:03 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZlYu0-0001YG-43 for pgsql-admin@postgresql.org; Mon, 12 Oct 2015 08:56:16 +0000 Received: from [59.151.11.101] (helo=Exchange02.qunarservers.com) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZlYtq-0004OV-UL for pgsql-admin@postgresql.org; Mon, 12 Oct 2015 08:56:13 +0000 Received: from Exchange10.qunarservers.com (192.168.38.247) by EXCHANGE02.qunarservers.com (192.168.23.12) with Microsoft SMTP Server (TLS) id 14.3.123.3; Mon, 12 Oct 2015 16:55:42 +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; Mon, 12 Oct 2015 16:55:43 +0800 Message-ID: <561B756E.8020800@qunar.com> Date: Mon, 12 Oct 2015 16:55:10 +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> <5618C644.8010809@qunar.com> <561B6799.2040300@postgrespro.ru> In-Reply-To: <561B6799.2040300@postgrespro.ru> Content-Type: multipart/alternative; boundary="------------080001020200010603040700" 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 --------------080001020200010603040700 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit I'm sorry I had not helped. can you show the files： 1. cat /etc/cluster/cluster.conf 2. ls /etc/corosync/service.d/ .if the directory is not empty , show config files 3. pcs cluster cib /tmp/cib.cfg && cat /tmp/cib.cfg 4. cat /etc/corosync/corosync.conf 5. tailf -n 100 /var/log/cluster/corosync.log 6. /var/log/message On 2015年10月12日 15:56, Nikolay Popov wrote: > 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 >> Nikolay Popov n.popov@postgrespro.ru Postgres Professional: >> http://www.postgrespro.com The Russian Postgres Company > -- ---------------------- 张文升 | PostgreSQL DBA ---------------------- --------------080001020200010603040700 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 8bit
I'm sorry I had not helped.
can you show the files：

1. cat /etc/cluster/cluster.conf
2. ls /etc/corosync/service.d/ .if the directory is not empty , show config files
3. pcs cluster cib /tmp/cib.cfg  && cat /tmp/cib.cfg
4. cat /etc/corosync/corosync.conf
5. tailf -n 100 /var/log/cluster/corosync.log
6. /var/log/message



On 2015年10月12日 15:56, Nikolay Popov wrote:
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
Nikolay Popov n.popov@postgrespro.ru Postgres Professional: http://www.postgrespro.com The Russian Postgres Company


-- 
----------------------
张文升 | PostgreSQL DBA 
----------------------
--------------080001020200010603040700--