Script to backup and replicate database using ddboost in DR env

Post date: Aug 27, 2014 4:31:9 PM

Backup database in DR env

gpcrondump -x <dbname> -z --ddboost --replicate --max-streams 50 –a


gpcrondump is a wrapper utility for gp_dump, which can be called directly or from a crontab entry.


gpcrondump -x database_name 

[-s schema | -t schema.table | -T schema.table] 

[-w dbid[,...]] [-u backup_directory] 

[-R post_dump_script] [-c | -o] [-z] [-r] [-f free_space_percent]

[-b] [-i] [-j | -k] [-g] [-G] [-C] [-d master_data_directory] 

[-B parallel_processes] [-a] [-q] 

[-y reportfile] [-l logfile_directory] [-D] 

{ [-E encoding] [--inserts | --column-inserts] [--oids]

[--no-owner | --use-set-session-authorization]

[--no-privileges] }

gpcrondump -?

gpcrondump -v


Restore the backup in the DR env

gpdbrestore -t 20120804040014 -v --ddboost -l /var/tmp –a

Note: -G will get all the global objects including roles and resource queues. –g will copy all the configuration files pg_hba.conf, postgresql.conf and pg_ident.conf (if there).


gp_restore=>Restores Greenplum databases that were backed up using gp_dump.


gp_restore --gp-k=timestamp_key -d database_name [-i] [-v] [-a |

-s] [-c] [-h hostname] [-p port] [-U username] [-W] [--gp-c]

[--gp-i] [--gp-d=directoryname] [--gp-r=reportfile] [--gp-l=dbid

[, ...]]

gp_restore -? | -h | --help

gp_restore --version