CODEWITHSUNDEEP
postgresqlreplicationtimescaledbpglogical
Tom
Tom

Reputation: 91

Is logical replication using pglogical possible with timescaleDB?

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.

Upvotes: 7

Views: 1436

Answers (1)

Tim Menapace
Tim Menapace

Reputation: 489

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

Upvotes: 1

Related Questions