Convert PG to Citus coordinator

[Timur Luchkin]

Hi,
I want to migrate huge PG DB to Citus onPrem. I saw your guide to use Debezium (or similar) to replicate existing data to new Citus cluster.
But due to some reasons I want to do next:
1) Install Citus extension right to the existing PG DB and use it as a Coordinator.
2) Add new servers with Citus workers to this coordinator
3) Migrate (and shard) some tables using Debezium (it will use slot/wal on existing coordinator, and data will be inserted to the same coordinator again, but to the sharded tables with new names)
4) Some tables will not be sharded and will stay on the Coordinator (at least for now). Later I want shard it using method from step 3. 

Is it possible? What pitfalls to expect?

[Onur Tırtır]

If you're planning to the use "existing node as the coordinator" and to add new nodes as the worker nodes, you might not need to use Debezium or anything else.

I'd suggest you to have a look into create_distributed_table_concurrently() UDF that allows you to shard your local tables without blocking reads & writes.

24 Ocak 2023 Salı tarihinde saat 17:45:22 UTC+3 itibarıyla timur....@skywindgroup.com şunları yazdı: