How do backup from one Citus cluster and restore to another?

[YMikheev]

We are trying to use pg_dump/pg_restore, but it doesn't work. I think because of metadata difference between Citus coordinator and Postgress. Perhaps there is another utility?

[tejeswarm]

@YMikheev pg_dump/restore should work, what was the issue you are seeing using pg_dump/pg_restore ? Are you dumping, restore and then distributing the data? If you can detail the steps you are taking that will help

In future, we will add the support for Citus-to-Citus directly in pgcopydb
https://github.com/dimitri/pgcopydb

[YMikheev]

@tejeswarm
As a result, we managed to do backup/restore using pg_dump/pg_restore on a Citus. It wasn't easy.
The speed of archiving and recovery is quite low.

When do you plan to add the support for Citus-to-Citus directly in pgcopydb?
pgcopydb look interesting for as.

And, do you plan to add schema compare for Citus?

[YMikheev]

@tejeswarm do you now real cases of using pgcopydb for Citus-to-Citus?