- Pivotal Greenplum Database (GPDB) 4.3.x
- Operating System- Red Hat Enterprise Linux 6.x
Transferring the full source database (which has multiple database schemas) to a destination database via gptransfer results in the below error in the gptransfer logs found under gpAdminLogs.
[ERROR]:-Failed to transfer table source.schema1.test
[WARNING]:-Some tables failed to transfer.
The cause of the issue has been identified as a bug (25569) in the database version below 126.96.36.199, where only one schema gets created and the remaining relations under different schema errors out.
Refer to the release notes of Pivotal Greenplum version 188.8.131.52 for more details on the bug.
Upgrade the database to 184.108.40.206 or later to overcome the issue.
Follow the steps:
1. Before executing the gptransfer command, create all the schema from the source to the target database using.
CREATE SCHEMA <SCHEMA_NAME>
2. Execute the gptransfer command again.