From: 张文升 <wensheng.zhang@qunar.com>
To: Nikolay Popov <n.popov@postgrespro.ru>
To: pgsql-admin@postgresql.org
Subject: Re: Pacemaker dynamic membership
Date: Mon, 12 Oct 2015 16:55:10 +0800
Message-ID: <561B756E.8020800@qunar.com> (raw)
In-Reply-To: <561B6799.2040300@postgrespro.ru>
References: <5614CD4A.7020900@postgrespro.ru>
<5618C644.8010809@qunar.com>
<561B6799.2040300@postgrespro.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
----------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wensheng.zhang@qunar.com, n.popov@postgrespro.ru
Subject: Re: Pacemaker dynamic membership
In-Reply-To: <561B756E.8020800@qunar.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox