public inbox for [email protected]help / color / mirror / Atom feed
Re: Regarding publish_via_partiton_root with pglogical 3+ messages / 2 participants [nested] [flat]
* Re: Regarding publish_via_partiton_root with pglogical @ 2024-09-28 05:39 Durgamahesh Manne <[email protected]> 2024-09-28 15:00 ` Re: Regarding publish_via_partiton_root with pglogical Greg Sabino Mullane <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Durgamahesh Manne @ 2024-09-28 05:39 UTC (permalink / raw) To: ; +Cc: [email protected]; [email protected] Hi Any inputs from the PGDG team members regarding this ? Regards Durga Mahesh On Mon, Jul 22, 2024 at 3:35 PM khan Affan <[email protected]> wrote: > Hi Durgamahesh > > In pglogical extension, there is no direct equivalent to the > publish_via_partition_root option found in the built-in logical replication > > you can achieve similar results when a new partition is added; you must > add it to the replication set using pglogical.replication_set_add_table. > Similarly existing partitions are reorganized or split, ensure to update > the replication sets accordingly. > > Thanks & Regards > > > *Muhammad Affan (*아판*)* > > *PostgreSQL Technical Support Engineer** / Pakistan R&D* > > Interlace Plaza 4th floor Twinhub office 32 I8 Markaz, Islamabad, Pakistan > > On Sat, Jul 20, 2024 at 12:00 PM Durgamahesh Manne < > [email protected]> wrote: > >> Hi >> >> Respected Team >> >> I know the use case of implementing the partitions with publication and >> subscription of built-in logical replication >> CREATE PUBLICATION dbz_publication FOR TABLE betplacement.bet WITH >> (publish_via_partition_root = true); This will use parent table to replica >> data changes to target from source >> But >> Could you please provide a logic to implement the same with pglogical ? >> Do i need to add this publish_via_partition_root to >> pglogical.replication_set_add_table functionality ? >> you response is valuable in this aspect >> >> Regards, >> Durga Mahesh >> > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Regarding publish_via_partiton_root with pglogical 2024-09-28 05:39 Re: Regarding publish_via_partiton_root with pglogical Durgamahesh Manne <[email protected]> @ 2024-09-28 15:00 ` Greg Sabino Mullane <[email protected]> 2024-09-28 16:55 ` Re: Regarding publish_via_partiton_root with pglogical Durgamahesh Manne <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Greg Sabino Mullane @ 2024-09-28 15:00 UTC (permalink / raw) To: Durgamahesh Manne <[email protected]>; +Cc: [email protected]; [email protected] Please do not spam the mailing lists with requests for follow ups. In this particular case, you received an answer two days after you posted it. It went to both psql-general, pgsql-in-general, and to you directly, so there seems little excuse for missing it. Also note that pglogical is a third-party extension and as such you may have more success in the future asking the maintainers of it via its github page (as I see you have done, although in a somewhat impolite way: https://github.com/2ndQuadrant/pglogical/issues/487) Cheers, Greg ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Regarding publish_via_partiton_root with pglogical 2024-09-28 05:39 Re: Regarding publish_via_partiton_root with pglogical Durgamahesh Manne <[email protected]> 2024-09-28 15:00 ` Re: Regarding publish_via_partiton_root with pglogical Greg Sabino Mullane <[email protected]> @ 2024-09-28 16:55 ` Durgamahesh Manne <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Durgamahesh Manne @ 2024-09-28 16:55 UTC (permalink / raw) To: Greg Sabino Mullane <[email protected]>; +Cc: [email protected] Hey Greg Thank you Regards, Durga Mahesh On Sat, 28 Sept, 2024, 20:31 Greg Sabino Mullane, <[email protected]> wrote: > Please do not spam the mailing lists with requests for follow ups. In this > particular case, you received an answer two days after you posted it. It > went to both psql-general, pgsql-in-general, and to you directly, so there > seems little excuse for missing it. > > Also note that pglogical is a third-party extension and as such you may > have more success in the future asking the maintainers of it via its github > page (as I see you have done, although in a somewhat impolite way: > https://github.com/2ndQuadrant/pglogical/issues/487) > > Cheers, > Greg > > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-09-28 16:55 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-09-28 05:39 Re: Regarding publish_via_partiton_root with pglogical Durgamahesh Manne <[email protected]> 2024-09-28 15:00 ` Greg Sabino Mullane <[email protected]> 2024-09-28 16:55 ` Durgamahesh Manne <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox