How Do I Clone My Production Databaes To Preprod / Qa Environment?

1.	How Do I Clone My Production Databaes To Preprod / Qa Environment?
Answer» If Prod and QA on same GPDB CLUSTER, use CREATE DATABASE <Clone_DBname> TEMPLATE <Source_DB>. If Prod and QA are on different clusters, use backup and RESTORE utilities.

Answer»

If Prod and QA on same GPDB CLUSTER, use CREATE DATABASE <Clone_DBname> TEMPLATE <Source_DB>.
If Prod and QA are on different clusters, use backup and RESTORE utilities.

Discussion