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
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 |