exporting data is done via COPY TO. Exports can go to the local filesystem or amazon s3.
every node containing data will export in parallel. you can export to a network attached storage or s3 or simply copy the exported files to another host using scp.