Re: BUG #13443: master will remove dead rows when hot standby(use slot) disconnect

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: 德哥 <digoal(at)126(dot)com>
Cc: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13443: master will remove dead rows when hot standby(use slot) disconnect
Date: 2015-06-17 17:58:53
Message-ID: CAMkU=1xa6_tCWpWW=R2AXJD3_LJ6vuYN85GCaMdiqtU-BxpXog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Jun 15, 2015 at 6:20 PM, 德哥 <digoal(at)126(dot)com> wrote:
> At 2015-06-16 08:52:48, "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com>
wrote:
> >On Tue, Jun 16, 2015 at 4:30 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
> >> On Mon, Jun 15, 2015 at 2:05 AM, <digoal(at)126(dot)com> wrote:
>
> >> One potential doc bug I see is that the it seems to imply that
replication
> >> slots replaces the need for hot_standby_feedback, when it fact it must
be
> >> used in conjunction with it. Do you have hot_standby_feedback turned
on in
> >> the standby?
>
> yes, i'm not open the hot_standby_feedback, thanks. When open it, no
problem now.

Sorry, I missed this sentence when I first read your reply. I thought you
still had an issue, but now I see that the only problem is that both of us
were confused by the documentation wording.

Incidentally for anyone wanting to do similar tests, 'ifdown lo' is ignored
on ubuntu trusty, you have to use 'ifconfig lo down' instead to take down
the loopback interface.

Cheers,

Jeff

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-06-18 00:39:52 Re: BUG #13448: DOC about : pg_dump use logical replication snapshot
Previous Message Tom Lane 2015-06-17 16:55:59 Re: ERROR: could not open relation with OID 22617039