Re: Support logical replication of DDLs - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Support logical replication of DDLs
Date
Msg-id CAJ7c6TP2=_k-w0rDrqbn6A40qEQcZ=kwVf18+YsfowbFL0o3Pg@mail.gmail.com
Whole thread Raw
In response to Re: Support logical replication of DDLs  (Zheng Li <zhengli10@gmail.com>)
List pgsql-hackers
Hi Zheng,

> >Also, I suspect that implementing it may be a bit challenging. What if we
> >focus on table-level replication for now?
>
> I think it is due to the fact that the current limitations in logical
> replication are
> holding it back in major version upgrade (MVU). Online / reduced downtime MVU
> is a popular request from customers, and why we should enhance logical
> replication
> to support this use case.
>
> Also I think table-level DDL replication is actually more challenging,
> especially in
> the FOR TABLE case, due to the fact that differences are expected to
> occur between the
> source and target database. Marcos’ comment also justifies the complexity
> in this case. Whereas database-level DDL replication in the FOR ALL
> TABLE case is
> relatively simple because the source and target database are (almost) identical.

Sure, I don't insist on implementing table-level replication first.
It's up to you. My point was that it's not necessary to implement
everything at once.

--
Best regards,
Aleksander Alekseev



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Design of pg_stat_subscription_workers vs pgstats
Next
From: Aleksander Alekseev
Date:
Subject: Re: PATCH: add "--config-file=" option to pg_rewind