![]() You can download gpcopy from VMware Tanzu Network. If you are copying data between Greenplum Database systems having different versions, each system must have gpcopy installed locally. The source and destination Greenplum Database systems must already exist, have network access between all hosts, and have coordinator host and primary segment hosts in both systems. The gpcopy utility includes the -truncate-source-after option to help migrate data from one VMware Greenplum system to another on the same hardware, requiring minimal free space available. A lock is not acquired on the source table when data is copied. Gpcopy allows the source table data to change while the data is being copied. Gpcopy provides detailed reporting and summary information about all aspects of the copy operation. Gpcopy can migrate data between Greenplum Database systems where the source and destination systems are configured with a different number of segment instances. Gpcopy is a command-line tool that includes these features: Extensions installed in the database with gppkg, such as MADlib and programming language extensions, must be installed in the destination database by an administrator. If a copied table or database does not exist in the destination system, gpcopy creates it automatically, along with indexes as necessary.Ĭonfiguration files, including nf and pg_hba.conf, must be transferred manually by an administrator. A full database transfer includes the database schema, table data, indexes, views, roles, user-defined functions, resource queues, and resource groups. The gpcopy interface includes options to transfer one or more full databases, or one or more database tables. gpcopy supports migrating data from a Greenplum Database version 4.23.6 (or later) system to a 5.9 (or later) or a 6.x Greenplum system, or from a Greenplum Database version 5.9+ system to a Greenplum 6.x system. You can migrate data between different Greenplum Database versions. You can migrate the entire contents of a database, or just selected tables. Gpcopy is a high-performance utility that can copy metadata and data from one Greenplum database to another Greenplum database. You can use the gpcopy utility to transfer data between databases in different Greenplum Database systems.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |