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.