We have migrated to new Google sites!
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.
Syntax
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.
Syntax
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
==============================