GitHub user Yohimbe227 edited a comment on the discussion: Migrate to Apache
Cloudberry
Hi!
I launched the cluster, there were a bunch of problems, but in the end it
worked.
But I can't beat cbcopy!
It got to the point where I wrote IP addresses instead of names everywhere, but
I still get an error like this:
```
[gpadmin@mdw ~]$ cbcopy --with-global-metadata --source-host=10.81.1.3
--source-port=5432 --source-user=gpadmin --dest-host=10.81.200.3
--dest-port=5432 --dest-user=gpadmin --schema=adb.test
--dest-schema=adb.test --truncate
20251006:09:59:31 cbcopy:gpadmin:mdw:045523-[INFO]:-Starting copy
(timestamp=20251006095931)...
20251006:09:59:31 cbcopy:gpadmin:mdw:045523-[INFO]:-Establishing 1 source db
management connection(s)...
20251006:09:59:31 cbcopy:gpadmin:mdw:045523-[INFO]:-Initialized database
version - Full Version: PostgreSQL 9.4.24 (Greenplum Database 6.8.1 build
6.8.1_arenadata5-173.el7) on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit compiled on Jun 22 2020 14:36:57,
Database Type: Greenplum Database, Semantic Version: 6.8.1
20251006:09:59:31 cbcopy:gpadmin:mdw:045523-[INFO]:-Establishing 4 dest db
management connection(s)...
20251006:09:59:31 cbcopy:gpadmin:mdw:045523-[INFO]:-Initialized database
version - Full Version: PostgreSQL 14.4 (Apache Cloudberry 2.0.0-incubating
build 1) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.3.1 20250418 (RED
SOFT 13.3.1-3), 64-bit compiled on Sep 26 2025 10:52:13 (with assert checking),
Database Type: Apache Cloudberry Database, Semantic Version: 2.0.0
20251006:09:59:31 cbcopy:gpadmin:mdw:045523-[CRITICAL]:-Dest segment
"10.80.209.4" should return only one IP address: Query was:
SELECT id As content, content AS hostname
FROM cbcopy_hosts_temp_20251006095931_0
```
I suspect that the problem is that I have 2 primary and 2 mirror on
each node.
I'm out of options :(
GitHub link:
https://github.com/apache/cloudberry/discussions/1371#discussioncomment-14601752
----
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]
