Is logical replication using pglogical possible with timescaleDB?

Question

I set up a fully functional logical replication of multiple masters to one slave.

As soon as I convert any of the replicated tables to timescaleDB's hypertable, the replication stops working - only the structure is replicated, but no data.

Is it possible to use timescaleDB together with pglogical? Would it be possible to use PostgreSQL 10 and its in-built logical replication abilities?

My guess is, that logical replication doesn't make sense in the context of tables consisting of virtual chunks.

Redwood

chunks in TimescaleDB db are partitions of the main hypertable interconnected with inheritance. Therefore read this - blog.2ndquadrant.com/… - it should help you – February

I set pglogical.conflict_resolution = error and pglogical.use_spi = true like suggested; it still doesn't work and just replicates structures. The proposed pglogical.conflict_resolution = false is wrong and leads to errors, by the way. – Redwood

Answer 1

No.

To our knowledge, PG10's logical replication will not work with hypertables, because it actually doesn't replicate DDL commands, and instead just does a pub/sub on the data.
- Mike Freedman, CTO TimescaleDB (04.04.2019)

More info: https://github.com/timescale/timescaledb/issues/1138#issuecomment-479674594

Ashleeashleigh