Non-Parallel Backup Support in Greenplum
Post date: Feb 02, 2014 9:44:6 PM
Greenplum is built on top of PostgreSQL. Greenplum supports the PostgreSQL non-parallel backup utilities pg_dump and pg_dumpall to enable migration from PostgreSQL to Greenplum Database.
These utilities create a single dump file on the master host that contains all data from all active segments. In most cases, the master host does not have enough disk space for a single backup file of a distributed database.
Greenplum supports the COPY TO SQL command for copying all or a portion of a table out of the database to a text-delimited file on the master host.