How do I restore a database dump to a Citus cluster?

Question

While restoring a (pg_dump-produced) database dump, I get the following error:

Cannot execute COPY FROM on a distributed table on master node

How can I work around this?

Answer 1

COPY support was added in Citus 5.1, which was released May 2016 and is available in the official PostgreSQL Linux package repositories (PGDG).

Are you trying to load data via a pg_dump output? Creating distributed tables is slightly different than regular tables, and requires picking of partition columns and partitioning method. Take a look at the docs to get more information on both.