Re: Pacemaker dynamic membership

From: 张文升 <wensheng(dot)zhang(at)qunar(dot)com>
To: Nikolay Popov <n(dot)popov(at)postgrespro(dot)ru>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Pacemaker dynamic membership
Date: 2015-10-10 08:03:16
Message-ID: 5618C644.8010809@qunar.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jan 2015-10-10 14:38:49 Re: Long-running and non-finishing VACUUM ANALYZE on large table
Previous Message Joshua D. Drake 2015-10-10 02:54:25 Re: streaming rep setup in PCI compliance environment