Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Why forcing Hot_standby_feedback to be enabled whencreating a logical decoding slot on standby - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [HACKERS] Why forcing Hot_standby_feedback to be enabled whencreating a logical decoding slot on standby
Date
Msg-id CAB7nPqQYPJUy46i8VUYN2eK_f+Be_0dyghndc18jBuRT90Ro3w@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Why forcing Hot_standby_feedback to be enabled when creating alogical decoding slot on standby  (sanyam jain <sanyamjain22@live.in>)
Responses Re: [HACKERS] Why forcing Hot_standby_feedback to be enabled whencreating a logical decoding slot on standby  (sanyam jain <sanyamjain22@live.in>)
List pgsql-hackers
Tree view 
On Mon, Jun 12, 2017 at 3:16 PM, sanyam jain <sanyamjain22@live.in> wrote:
> I have created a logical decoding slot on a standby but i haven't enabled
> Hot_standby_feedback.What are the test cases where this setup will fail?

hot_standby_feedback needs to be enabled at all times in logical
decoding so as the node does not remove rows that are still needed for
the decoding, and a VACUUM passing by with a minimal xmin too high
would cause inconsistent decoded data.
-- 
Michael

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] ICU support on Windows
Next
From: Amit Langote
Date:
Subject: Re: [HACKERS] A bug in mapping attributes in ATExecAttachPartition()