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