GitHub user edespino added a comment to the discussion: Migrate to Apache
Cloudberry
@Yohimbe227 Using cbcopy, I was able to perform multiple copy variants from an
arenadata cluster (2 segments, 2 primaries/mirrors per segment) to a Cloudberry
(main branch) of the same topology. From my perspective, there is nothing fancy
I did to get my AWS VM clusters running. I am willing to get in a zoom session
with you to share my config.
These are the basic commands I ran:
```
Option A: Migrate entire database
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
Option B: Migrate specific schema
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
Option C: Migrate specific table
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
```
GitHub link:
https://github.com/apache/cloudberry/discussions/1371#discussioncomment-14623175
----
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]
