From: 张文升 <wensheng.zhang@qunar.com>
To: Nikolay Popov <n.popov@postgrespro.ru>
To: pgsql-admin@postgresql.org
Subject: Re: Pacemaker dynamic membership
Date: Sat, 10 Oct 2015 16:03:16 +0800
Message-ID: <5618C644.8010809@qunar.com> (raw)
In-Reply-To: <5614CD4A.7020900@postgrespro.ru>
References: <5614CD4A.7020900@postgrespro.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
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: <5618C644.8010809@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