Re: CDC/ETL system on top of logical replication with pgoutput, custom client

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: José Neves <rafaneves3(at)msn(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: CDC/ETL system on top of logical replication with pgoutput, custom client
Date: 2023-08-07 04:59:54
Message-ID: CAA4eK1JLB6BNAeF6Zb7=mai2D_zQSX5ndp3Xu7997R1sm=981g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Aug 6, 2023 at 7:54 PM José Neves <rafaneves3(at)msn(dot)com> wrote:
>
> A follow-up on this. Indeed, a new commit-based approach solved my missing data issues.
> But, getting back to the previous examples, how are server times expected to be logged for the xlogs containing these records?
>

I think it should be based on commit_time because as far as I see we
can only get that on the client.

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2023-08-07 05:30:13 Re: [PoC] pg_upgrade: allow to upgrade publisher node
Previous Message Thomas Munro 2023-08-07 04:49:00 Re: Postmaster self-deadlock due to PLT linkage resolution