GitHub user edespino added a comment to the discussion: Migrate to Apache Cloudberry
Here is a sample of the execution of the three options I tried: ``` cbadmin in 🌐 adw in arenadata/master/gpseg-1 ❯ # Option A: Migrate entire database cbadmin in 🌐 adw in arenadata/master/gpseg-1 ❯ cbcopy \ ∙ --source-host=adw --source-port=5432 --source-user=cbadmin \ ∙ --dest-host=cdw --dest-port=5432 --dest-user=cbadmin \ ∙ --dbname=test_source \ ∙ --dest-dbname=test_target \ ∙ --truncate --verbose 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Starting copy (timestamp=20251008011644)... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Establishing 1 source db management connection(s)... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Establishing 4 dest db management connection(s)... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Establishing 1 source db (test_source) metadata connection(s)... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Establishing 2 dest db (test_target) metadata connection(s)... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Establishing 4 dest db (test_target) data connection(s)... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Establishing 4 source db (test_source) data connection(s)... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Retrieving user tables on source database "test_source"... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Finished retrieving user tables 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Retrieving partition table on source database "test_source"... 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Finished retrieving partition tables 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Copying metadata from database "test_source" to "test_target" 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Metadata will be written to /home/cbadmin/gpAdminLogs/cbcopy_meta_20251008011644 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Gathering additional table metadata 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting column definitions 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting distribution policies 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Getting partition definitions 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Getting storage information 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving external table information 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting table type 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting access method 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting table replica identity 20251008:01:16:44 cbcopy:cbadmin:adw:067184-[INFO]:-Getting child partitions with altered schema 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Constructing table definition map 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing Session Configuration Parameters to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Writing global database metadata 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE RESOURCE QUEUE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE RESOURCE GROUP statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE ROLE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_authid 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing GRANT ROLE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE TABLESPACE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_tablespace 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing Database Configuration Parameters to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing ROLE Configuration Parameter to meadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Global database metadata backup complete 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Writing pre-data metadata 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving function information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_proc 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_class 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving protocols 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_extprotocol 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE SCHEMA statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_namespace 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE EXTENSION statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE COLLATION statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_collation 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving type information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting shell types 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting base types 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting composite types 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting composite type attributes 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting domain types 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving range types 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_type 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE TYPE statements for shell types to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE TYPE statements for enum types to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE PROCEDURAL LANGUAGE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_language 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE FOREIGN DATA WRAPPER statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_foreign_data_wrapper 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE SERVER statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_foreign_server 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE USER MAPPING statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving Text Search Parsers 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving Text Search Parsers 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving TEXT SEARCH CONFIGURATION information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_ts_config 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving TEXT SEARCH TEMPLATE information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving TEXT SEARCH DICTIONARY information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_ts_dict 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE OPERATOR FAMILY statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_opfamily 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving OPERATOR information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_operator 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving OPERATOR CLASS information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_opclass 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving AGGREGATE information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_proc 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving CAST information 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving views 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting distribution policies 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE SEQUENCE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Retrieving constraints 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE statements for dependent objects to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing ALTER SEQUENCE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE CONVERSION statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_conversion 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Pre-data metadata backup complete 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Writing post-data metadata 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE INDEX statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE RULE statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE TRIGGER statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing ALTER DEFAULT PRIVILEGES statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Writing CREATE EVENT TRIGGER statements to metadata file 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Getting object type metadata from pg_event_trigger 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Post-data metadata backup complete 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Metadata file written done 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Metadata will be restored from /home/cbadmin/gpAdminLogs/cbcopy_meta_20251008011644, WithGlobal: false 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Restoring pre-data metadata 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring schemas 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 5% (1/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 15% (2/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 25% (3/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 35% (4/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 45% (5/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 50% (6/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring extensions 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring collations 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring types 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring operator families 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring sequences 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 60% (7/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 70% (8/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring dependent objects in parallel mode 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 80% (9/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring procedural languages 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring exchange partitions 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring sequence owner 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 90% (10/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring conversions 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Restoring constraints 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[DEBUG]:-Pre-data objects restored: 100% (11/11) 20251008:01:16:45 cbcopy:cbadmin:adw:067184-[INFO]:-Pre-data metadata restore complete Pre-data objects restored: (11/11) [==========================================================] 100 % Pre-data objects restored: (11/11) [==========================================================] 100 % Table copied: (1/1) [==========================================================] 100 % 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[INFO]:-Database test_source: successfully copied 1 tables, skipped 0 tables, failed 0 tables 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[INFO]:-Restoring post-data metadata 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[INFO]:-Post-data metadata restore complete 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[INFO]:-file rename, MetaFile /home/cbadmin/gpAdminLogs/cbcopy_meta_20251008011644 --> /home/cbadmin/gpAdminLogs/cbcopy_meta _20251008011644.test_source.test_target.bk, TocFile /home/cbadmin/gpAdminLogs/cbcopy_toc_20251008011644 --> /home/cbadmin/gpAdminLogs/cbcopy_toc_20251008011644.test_sou rce.test_target.bk 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[INFO]:-Total elapsed time: 1.936346732s 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[DEBUG]:-Beginning cleanup 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[DEBUG]:-Cleanup complete 20251008:01:16:46 cbcopy:cbadmin:adw:067184-[INFO]:-Copy completed successfully cbadmin in 🌐 adw in arenadata/master/gpseg-1 took 2s ❯ # Option B: Migrate specific schema cbadmin in 🌐 adw in arenadata/master/gpseg-1 ❯ cbcopy \ ∙ --source-host=adw --source-port=5432 --source-user=cbadmin \ ∙ --dest-host=cdw --dest-port=5432 --dest-user=cbadmin \ ∙ --schema=test_source.test_schema \ ∙ --dest-schema=test_target.test_schema \ ∙ --truncate --verbose 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Starting copy (timestamp=20251008011704)... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Establishing 1 source db management connection(s)... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Establishing 4 dest db management connection(s)... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Establishing 1 source db (test_source) metadata connection(s)... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Establishing 2 dest db (test_target) metadata connection(s)... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Establishing 4 dest db (test_target) data connection(s)... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Establishing 4 source db (test_source) data connection(s)... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Retrieving user tables on source database "test_source"... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Finished retrieving user tables 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Retrieving partition table on source database "test_source"... 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Finished retrieving partition tables 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Copying metadata from schema "test_source.test_schema" => "test_target.test_schema" 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Metadata will be written to /home/cbadmin/gpAdminLogs/cbcopy_meta_20251008011704 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Gathering additional table metadata 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting column definitions 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting distribution policies 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Getting partition definitions 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Getting storage information 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving external table information 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting table type 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting access method 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting table replica identity 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Getting child partitions with altered schema 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Constructing table definition map 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing Session Configuration Parameters to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Writing global database metadata 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE RESOURCE QUEUE statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE RESOURCE GROUP statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE ROLE statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_authid 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing GRANT ROLE statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE TABLESPACE statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_tablespace 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing Database Configuration Parameters to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing ROLE Configuration Parameter to meadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Global database metadata backup complete 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[INFO]:-Writing pre-data metadata 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving function information 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_proc 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_class 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving protocols 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_extprotocol 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE SCHEMA statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_namespace 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE EXTENSION statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE COLLATION statements to metadata file 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_collation 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving type information 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting shell types 20251008:01:17:04 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting base types 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting composite types 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting composite type attributes 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting domain types 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving range types 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_type 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE TYPE statements for shell types to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE TYPE statements for enum types to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving Text Search Parsers 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving Text Search Parsers 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving TEXT SEARCH CONFIGURATION information 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_ts_config 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving TEXT SEARCH TEMPLATE information 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving TEXT SEARCH DICTIONARY information 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_ts_dict 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE OPERATOR FAMILY statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_opfamily 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving OPERATOR information 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_operator 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving OPERATOR CLASS information 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_opclass 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving AGGREGATE information 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_proc 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving CAST information 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving views 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting distribution policies 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE SEQUENCE statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Retrieving constraints 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE statements for dependent objects to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing ALTER SEQUENCE statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE CONVERSION statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Getting object type metadata from pg_conversion 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[INFO]:-Pre-data metadata backup complete 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[INFO]:-Writing post-data metadata 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE INDEX statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE RULE statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing CREATE TRIGGER statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Writing ALTER DEFAULT PRIVILEGES statements to metadata file 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[INFO]:-Post-data metadata backup complete 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[INFO]:-Metadata file written done 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[INFO]:-Metadata will be restored from /home/cbadmin/gpAdminLogs/cbcopy_meta_20251008011704, WithGlobal: false 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[INFO]:-Restoring pre-data metadata 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring schemas 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Pre-data objects restored: 10% (1/7) 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Pre-data objects restored: 25% (2/7) 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring extensions 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring collations 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring types 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring operator families 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring sequences 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Pre-data objects restored: 40% (3/7) 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Pre-data objects restored: 55% (4/7) 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring dependent objects in parallel mode 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Pre-data objects restored: 70% (5/7) 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring procedural languages 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring exchange partitions 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring sequence owner 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Pre-data objects restored: 85% (6/7) 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring conversions 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Restoring constraints 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[DEBUG]:-Pre-data objects restored: 100% (7/7) 20251008:01:17:05 cbcopy:cbadmin:adw:067276-[INFO]:-Pre-data metadata restore complete Pre-data objects restored: (7/7) [==========================================================] 100 % Pre-data objects restored: (7/7) [==========================================================] 100 % Pre-data objects restored: (7/7) [==========================================================] 100 % Table copied: (1/1) [==========================================================] 100 % 20251008:01:17:06 cbcopy:cbadmin:adw:067276-[INFO]:-Restoring post-data metadata 20251008:01:17:06 cbcopy:cbadmin:adw:067276-[INFO]:-Post-data metadata restore complete 20251008:01:17:06 cbcopy:cbadmin:adw:067276-[INFO]:-file rename, MetaFile /home/cbadmin/gpAdminLogs/cbcopy_meta_20251008011704 --> /home/cbadmin/gpAdminLogs/cbcopy_meta _20251008011704.test_source.test_target.bk, TocFile /home/cbadmin/gpAdminLogs/cbcopy_toc_20251008011704 --> /home/cbadmin/gpAdminLogs/cbcopy_toc_20251008011704.test_sou rce.test_target.bk 20251008:01:17:06 cbcopy:cbadmin:adw:067276-[INFO]:-Total elapsed time: 1.85293371s 20251008:01:17:06 cbcopy:cbadmin:adw:067276-[DEBUG]:-Beginning cleanup 20251008:01:17:06 cbcopy:cbadmin:adw:067276-[DEBUG]:-Cleanup complete 20251008:01:17:06 cbcopy:cbadmin:adw:067276-[INFO]:-Copy completed successfully cbadmin in 🌐 adw in arenadata/master/gpseg-1 took 2s ❯ # Option C: Migrate specific table cbadmin in 🌐 adw in arenadata/master/gpseg-1 ❯ cbcopy \ ∙ --source-host=adw --source-port=5432 --source-user=cbadmin \ ∙ --dest-host=cdw --dest-port=5432 --dest-user=cbadmin \ ∙ --include-table=test_source.test_schema.employees \ ∙ --dest-table=test_target.test_schema.employees \ ∙ --truncate --verbose 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Starting copy (timestamp=20251008011729)... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Establishing 1 source db management connection(s)... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Establishing 4 dest db management connection(s)... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Establishing 1 source db (test_source) metadata connection(s)... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Establishing 2 dest db (test_target) metadata connection(s)... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Establishing 4 dest db (test_target) data connection(s)... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Initialized database version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2134.g6e0c40bc6e6 bu ild dev) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 23:51:57 (with assert checking), Database Type: Apache Cloudberry Database, Semantic Version: 3.0.0 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Establishing 4 source db (test_source) data connection(s)... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Initialized database version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build dev) on x86_64-unknow n-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit compiled on Oct 7 2025 03:10:59 (with assert checking), Database Type: Greenplum Database, Semantic Version: 6.8.1 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Retrieving user tables on source database "test_source"... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Finished retrieving user tables 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Retrieving partition table on source database "test_source"... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Finished retrieving partition tables 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Retrieving user tables on destination database "test_target"... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Finished retrieving user tables 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Retrieving partition table on destination database "test_target"... 20251008:01:17:29 cbcopy:cbadmin:adw:067366-[INFO]:-Finished retrieving partition table Table copied: (0/1) [----------------------------------------------------------] 0 % Table copied: (1/1) [==========================================================] 100 % 20251008:01:17:30 cbcopy:cbadmin:adw:067366-[INFO]:-Database test_source: successfully copied 1 tables, skipped 0 tables, failed 0 tables 20251008:01:17:30 cbcopy:cbadmin:adw:067366-[INFO]:-Total elapsed time: 1.073848921s 20251008:01:17:30 cbcopy:cbadmin:adw:067366-[DEBUG]:-Beginning cleanup 20251008:01:17:30 cbcopy:cbadmin:adw:067366-[DEBUG]:-Cleanup complete 20251008:01:17:30 cbcopy:cbadmin:adw:067366-[INFO]:-Copy completed successfully cbadmin in 🌐 adw in arenadata/master/gpseg-1 ❯ ``` GitHub link: https://github.com/apache/cloudberry/discussions/1371#discussioncomment-14623280 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
