Migrate to Apache Cloudberry #1371
Answered
by
kongfanshen-0801
Yohimbe227
asked this question in
Q&A
-
|
Please advise whether it will be possible to migrate relatively painlessly from areanadata DB 6.8.1 to Apache Cloudberry. |
Beta Was this translation helpful? Give feedback.
Answered by
kongfanshen-0801
Sep 23, 2025
Replies: 8 comments 12 replies
-
|
Yes, I think migration is technically feasible and can be relatively painless, but it requires careful planning and execution. The pain level depends heavily on your specific use cases and data complexity. Factors Supporting "Painless" Migration
2.PostGIS Compatibility |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
I believe ADB 6.x is based on Greenplum Database 6.x, so for migration, you can try the tool https://github.com/cloudberry-contrib/cbcopy, which supports |
Beta Was this translation helpful? Give feedback.
Answer selected by
Yohimbe227
-
|
@Yohimbe227 If you’re able to share a copy or version details of Areanadata DB 6.8.1, I’d be happy to spin up a test environment and try out a migration using cbcopy together. That way we can validate the process step by step and confirm whether it works smoothly in your setup. |
Beta Was this translation helpful? Give feedback.
2 replies
-
|
https://github.com/arenadata/gpdb/releases/tag/6.8.1_arenadata5 |
Beta Was this translation helpful? Give feedback.
-
|
@Yohimbe227 Part 1 - Building from the source you provided: OS: Rocky Linux 8.10 (Green Obsidian) Clearly, this feels like the open source version of GP 6.8.1. Part 2 - Using cbcopy, migrating from this starting point should be very straightforward. Let me setup a quick test and I'll share the process flow asap. |
Beta Was this translation helpful? Give feedback.
-
|
@Yohimbe227 – I set up a very basic single-node configuration with Arenadata 5, Apache Cloudberry (main branch), and cbcopy (https://github.com/cloudberry-contrib/cbcopy). The migration worked smoothly, and there isn’t much complexity involved. You should be able to set up your own environment and validate the process fairly easily. The cbcopy README and running For reference, I used Rocky Linux 8.10, which turned out to be the simplest option for building both Arenadata and Cloudberry from source. If you’d like a small sandbox to test this, I’d be happy to provide an environment where you can run through the steps. Please feel free to reach out if you’d like further assistance. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Thank you very much for the information. It is very important to me. The situation is complicated by the fact that I have a specific RED OS 8 operating system. Yes, it is based on RHEEL, but who knows what changes have been made. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
@Yohimbe227 Thanks for sharing those details. RED OS 8 should behave similarly to RHEL 8, so in principle Cloudberry and cbcopy should work — but you’re right that vendor changes can sometimes introduce surprises. Since your setup is 1 master and 2 segment nodes, you should be able to start with a straightforward deployment and test the migration workflow end to end. If you run into issues building or deploying on RED OS 8, I’d be glad to help troubleshoot. There are also other things to consider in this type of migration. Does your Arenadata cluster use any extensions or additional GP tooling (for example, PXF)? You may need to set these up in the Cloudberry environment to have a reasonable chance of providing an application/analytics environment that closely matches your original setup. Please feel free to reach out if you’d like assistance at any stage. |
Beta Was this translation helpful? Give feedback.
0 replies
-
|
Hi! |
Beta Was this translation helpful? Give feedback.
3 replies
-
|
@Yohimbe227 I am a bit confused ... "in the end it worked" or "I'm out of options" ... Do you need assistance? |
Beta Was this translation helpful? Give feedback.
-
|
"It worked" it's to make cluster, and "no options" to cbcopy. |
Beta Was this translation helpful? Give feedback.
-
|
Ahhh ... Can you share the exact topology of your arenadata cluster (number of nodes, number of primaries and mirrors per node)? |
Beta Was this translation helpful? Give feedback.
-
|
1 master node, 2 segment nodes. 2 primary segments and 2 mirror segments on each segment nodes. |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Looks straightforward enough to spin up. Do you have a test schema or some mock data I could use to try out the cbcopy workflow? |
Beta Was this translation helpful? Give feedback.
-
|
@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: |
Beta Was this translation helpful? Give feedback.
5 replies
-
|
Here is a sample of the execution of the three options I tried: |
Beta Was this translation helpful? Give feedback.
-
|
Beta Was this translation helpful? Give feedback.
-
|
Thanks for your answers. Yesterday, I dealt with this problem again and tried the pull method instead of push, and things started moving forward. After tinkering around a bit more, I went back to push, and the multi-IP error disappeared. Perhaps I fixed something else, I can't remember exactly, but now everything is working and cbcopy is working great. However, judging by I ran a few schemes and everything is OK! |
Beta Was this translation helpful? Give feedback.
-
|
Sorry for asking a question that is not entirely relevant to the topic. But my bosses really want to know if there is a deadline for when this project will leave the incubator. |
Beta Was this translation helpful? Give feedback.
-
|
@Yohimbe227 There isn’t a set date or deadline for when projects graduate from Apache Incubation — it depends on community growth, governance maturity, transparency, and alignment with ASF principles. What matters most is steady progress, open collaboration, and active participation. We’ve completed our first release (v2.0.0) and plan to continue with several more as we build momentum toward graduation. Your questions and participation help shape the project in a positive and transparent way. Please keep asking questions, sharing feedback, and helping others — every contribution truly makes a difference! |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Yes, I think migration is technically feasible and can be relatively painless, but it requires careful planning and execution. The pain level depends heavily on your specific use cases and data complexity.
Factors Supporting "Painless" Migration
,SQL syntax, data types, and core functionality are largely compatible.
2.PostGIS Compatibility
AreaData DB 6.8.1 likely uses PostGIS 2.x/3.x
Cloudberry supports modern PostGIS versions
Spatial operations and functions will translate well.