Logical replication to partitioned subscriber - Mailing list pgsql-hackers

From Jeremy Finzel
Subject Logical replication to partitioned subscriber
Date
Msg-id CAMa1XUimE8wUdjKGuNM2FhXo92uBm8UAoMYczC_wGE5FFncbUA@mail.gmail.com
Whole thread Raw
Responses Re: Logical replication to partitioned subscriber  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Are there any plans to support logical replication to a table which is only partitioned on the subscriber?  We are very interested in such a feature for a couple use cases.  We are using logical replication for archiving data and we only want it partitioned on the archive server, and we want it to just work transparently with logical replication.

Another use case is to convert a huge OLTP database table to be partitioned, and as opposed to writing a script, use logical replication to replicate to a destination replica which has the partitioning work done online, then swap nodes.

We are using pglogical, but I see from the docs that the same limitations apply even in pg11's built-in logical replication.

Thanks!
Jeremy

pgsql-hackers by date:

Previous
From: Jeremy Finzel
Date:
Subject: Delta Materialized View Refreshes?
Next
From: Jordan Deitch
Date:
Subject: Re: Delta Materialized View Refreshes?