Problem restoring Greenplum backups on CloudberryDB

[svnZA]

Good morning,

Firstly, I want to express my gratitude for the fantastic work you’re doing, it's truly appreciated.

We are in the process of transitioning from Greenplum 6.17.1 to CloudberryDB 1.6.0. My cluster is already set up and running (1 x Master, 1 x Master Standby, and 8 x Segment servers). However, I’m encountering the following error when attempting to restore my Greenplum backups on CloudberryDB:

[CRITICAL]:-gprestore 1.6.0 cannot restore a backup taken with gpbackup 1.20.4; please use gprestore 1.20.4 or later.

Your assistance in resolving this issue would be greatly appreciated.

Thank you in advance for your support.

Best regards,
Henk V

[my-ship-it]

Hi @svnZA, did you use gpbackup to backup Greenplum 6.17.1 provided by Cloudberry?

[svnZA]

Good morning,

Yes, that is what I used.

gpbackup version 1.20.4

gpbackup --dbname "cdrfw" --compression-level 9 --metadata-only --verbose --backup-dir /backup/gpbackups

[my-ship-it]

You can go to Slack for more help, where there are many enthusiastic people

[svnZA]

I noticed the following on the roadmap "Migration tool to help users migrate from Greenplum to Cloudberry Database."

But surely there has been a number of people moving from GP to CloudberryDB, so this can't be a new thing :)

[jianlirong]

Actually, there indeed is an open-sourced migration tool: https://github.com/HashDataInc/cbcopy You can have a try. Thanks, Lirong svnZA ***@***.***> 于2024年11月28日周四 16:45写道：

…

I noticed the following on the roadmap "Migration tool to help users migrate from Greenplum to Cloudberry Database." But surely there has been a number of people moving from GP to CloudberryDB, so this can't be a new thing :) — Reply to this email directly, view it on GitHub <#737 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAD6XVEIRKQEJHNFV6TSVKT2C3JZRAVCNFSM6AAAAABSUP4JFCVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCNBQGM3DONA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[svnZA]

Thank you, much appreciated.

[xanadu-dev]

Good morning,

Firstly, I want to express my gratitude for the fantastic work you’re doing, it's truly appreciated.

We are in the process of transitioning from Greenplum 6.17.1 to CloudberryDB 1.6.0. My cluster is already set up and running (1 x Master, 1 x Master Standby, and 8 x Segment servers). However, I’m encountering the following error when attempting to restore my Greenplum backups on CloudberryDB:

[CRITICAL]:-gprestore 1.6.0 cannot restore a backup taken with gpbackup 1.20.4; please use gprestore 1.20.4 or later.

Your assistance in resolving this issue would be greatly appreciated.

Thank you in advance for your support.

Best regards, Henk V

I faced a similar problem and simply disabled the version check, changing it from an error to a warning so that the process would continue - the restore worked perfectly fine. See apache/cloudberry-gpbackup#8

[my-ship-it]

Good morning,
Firstly, I want to express my gratitude for the fantastic work you’re doing, it's truly appreciated.
We are in the process of transitioning from Greenplum 6.17.1 to CloudberryDB 1.6.0. My cluster is already set up and running (1 x Master, 1 x Master Standby, and 8 x Segment servers). However, I’m encountering the following error when attempting to restore my Greenplum backups on CloudberryDB:
[CRITICAL]:-gprestore 1.6.0 cannot restore a backup taken with gpbackup 1.20.4; please use gprestore 1.20.4 or later.
Your assistance in resolving this issue would be greatly appreciated.
Thank you in advance for your support.
Best regards, Henk V

I faced a similar problem and simply disabled the version check, changing it from an error to a warning so that the process would continue - the restore worked perfectly fine. See apache/cloudberry-gpbackup#8

Thanks, we will have a look.

[my-ship-it]

Generally speaking, gpbackup is mainly used for database backup, not for upgrading, because different versions may have potential data compatibility issues.
If upgrading is needed, it is recommended to use the approach mentioned above.