Migrating Greenplum® clusters

You can migrate your database from a third-party Greenplum® or PostgreSQL cluster to Managed Service for Greenplum® using Yandex Data Transfer. This method allows you to:

• Migrate the database without interrupting user service.
• Migrate from older Greenplum® versions to newer versions.
• Go without creating an intermediate VM or granting online access to your Managed Service for PostgreSQL target cluster.

For more information, see What tasks Yandex Data Transfer is used for.

To migrate your database, you need to directly transfer the data, acquire a write lock for the old database, and switch over the load to the database cluster in Yandex Cloud.

Getting startedGetting started

Create a Managed Service for Greenplum® target cluster with the computing capacity and storage size appropriate for the environment where the migrated database is deployed.

The database name in the target cluster must be the same as the source database name.

Transferring dataTransferring data

1. Prepare the source cluster:

   • Greenplum®
   • PostgreSQL

2. Prepare the target cluster.

3. Create a source endpoint with the following parameters:

   • Database type: Greenplum or PostgreSQL

   • Endpoint parameters → Connection settings: Custom installation

     Specify the parameters for connecting to the source cluster.

4. Create a target endpoint with the following parameters:

   • Database type: Greenplum

   • Endpoint parameters → Connection settings: Managed Service for Greenplum cluster

     Specify the ID of the target cluster.

5. Create a transfer of the Snapshot type that will use the created endpoints.

6. Activate the transfer.

7. Wait for the transfer status to change to Completed.

   For more information about transfer statuses, see Transfer lifecycle.

8. Switch the source cluster to «read-only» mode and transfer the load to the target cluster.

9. Delete the completed transfer.

10. Delete endpoints for both the source and target.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of VMware, Inc. in the United States and/or other countries.