How do I COPY to a cstore_fdw table in Citus?

Question

I have configured cstore_fdw successfully on our CitusDB installation running on an Ubuntu server in AWS.

I tried to install the same on one of our client's servers running CentOS 6.5. I could install it but cannot execute COPY commands.

Is there any documentation on using COPY with cstore_fdw-based tables in Citus?

score 1 · Answer 1 · edited May 25 '16 at 22:07

1

CitusDB with cstore_fdw is supported, but CitusDB itself does not support COPY. Instead you can use the \STAGE command by following these instructions.

What's the specific error message you saw on Ubuntu vs. CentOS?

edited May 25 '16 at 22:07

jasonmp85

6,749
2
25
41

answered Aug 07 '15 at 10:30

Marco Slot

401
3
5

Murat Tuncer · Answer 2 · 2017-02-07T12:20:22.867

0

Citus supports COPY command starting from 5.1 release. You could use it as the same manner you would use with regular tables. Please see Citus documentation on bulk data loading.

edited Feb 07 '17 at 12:20

answered Jun 14 '16 at 08:00

Murat Tuncer

126
3

How do I COPY to a cstore_fdw table in Citus?

2 Answers2