Hello!
I’ve got a main and backup postgresql server where both have timescaledb and pglogical installed. I’d like to setup bi-directional replication using pglogical where my hypertables on my main psql db are replicated to backup and my backup psql db replicates to main with the most recent update taking priority. I’ve been able to set up BDR for normal tables that have not been updated to hypertables, but when I attempt to replicate a table that is a hypertable, it seems like the data isn’t being replicated from my main to my backup as my main has all the data and the backup doesn’t have any data. Currently, I’m only replicating the hypertable itself and no chunks or any other information, do I need to add additional tables to the replication to ensure the data replicates properly? Is there a set of tables that I need to add to my replication set that live within the timescaledb schemas? Is BDR even possible with hypertables?
Thanks for the help!