3

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?

jasonmp85
  • 6,749
  • 2
  • 25
  • 41
  • What partition method are you using? Can you please provide the commands you used to create your distributed table? – jasonmp85 May 25 '16 at 21:57

1 Answers1

3

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.

jasonmp85
  • 6,749
  • 2
  • 25
  • 41
Sumedh
  • 131
  • 4