From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Jov <amutu(at)amutu(dot)com> |
Cc: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: stand by is starting until I do some work in the primary |
Date: | 2014-02-24 15:27:06 |
Message-ID: | CABUevEwkM2jK_RgHicCQU-3_f2BYDbR6NSv+Sbon6w8262ZAZQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Feb 23, 2014 at 8:25 AM, Jov <amutu(at)amutu(dot)com> wrote:
> Sure.Before the restart,I have login in the slave many times.
> some more info ,but I don't think related:
> centOS 6 ,amd64,128GB memory,24 core, pgsql-9.3.3,master and slave in the
> same host.
>
> this is my first instance of 9.3,I don't exprence this before on 9.0~9.2.
>
>
>
It will probably work again after a CHECKPOINT (manual or automatic), if
there is *some* activity on the master. You may be experiencing what the
patch ed46758381ff63a422fcb0b1f2763eb13273640f, which will be included in
9.4. But the workaround is to make sure something happens on the master and
do a checkpoint.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Jon Nelson | 2014-02-24 17:38:01 | Re: Why does PostgreSQL ftruncate before unlink? |
Previous Message | Pavel Stehule | 2014-02-24 07:44:26 | Re: How to convert a double value to a numeric datum type in pgsql? |