Dump files created during (gp_dump) greenplum parallel backup command

posted Jan 17, 2015, 12:37 PM by Sachchida Ojha   [ updated May 20, 2016, 5:49 PM ]
Note: gp_dump is deprecated in later versions. use gpcrondump.
 Dump File Description
 In the master  
  gp_catalog_1_<dbid>_timestamp> System catalog tables
  gp_cdatabase_1_<dbid>_timestamp> CREATE DATABASE STATEMENT
  gp_dump_1_<dbid>_timestamp> Database Schemas -- DDL to create schema and database objects
  gp_dump_status_1_<dbid>_timestamp> Log file
 In the segment 
   gp_dump_0_<dbid>_timestamp> Data for the segment - default uses COPY Statements
   gp_dump_status_0_<dbid>_timestamp> log file

Note: each dump file has the timestamp key which identifies the backup set. This timestamp is needed by a restore to identify the backup set.