Обсуждение: Logical replication to partitioned subscriber
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
On 2018-Sep-14, Jeremy Finzel wrote: > 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. As I understand, in pglogical you can set pglogical.use_spi and it Should Work(tm). As for built-in replication, I'm afraid there's a small patch required to make it work, and nobody wrote it for pg11. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services