Migrating a database to Yandex MPP Analytics for PostgreSQL

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

• Migrate your database with zero downtime.
• Migrate from older to newer versions of Greenplum®.
• Eliminate the need for an intermediate VM or for exposing your Managed Service for PostgreSQL target cluster to the internet.

For more information, see Problems addressed by Yandex Data Transfer.

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.

Required paid resourcesRequired paid resources

• Yandex MPP Analytics for PostgreSQL cluster, which includes the use of computing resources allocated to hosts, storage and backup size (see Yandex MPP Analytics for PostgreSQL pricing).
• Each transfer: use of computing resources and the number of transferred data rows (see Data Transfer pricing).
• Public IP addresses if public access is enabled for cluster hosts (see Yandex Virtual Private Cloud pricing).

Getting startedGetting started

Create a Greenplum® target cluster with computing capacity and storage size matching the source database’s environment.

The source and target database names must be the same.

Transferring dataTransferring data

1. Prepare the source cluster:

   • Greenplum®
   • PostgreSQL

2. Prepare the target cluster.

3. Create a source endpoint with the following settings:

   • Database type: Greenplum or PostgreSQL.

   • Endpoint parameters → Connection settings: Custom installation.

     Configure the source cluster connection settings.

4. Create a target endpoint with the following settings:

   • Database type: Greenplum.

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

     Specify the target cluster ID.

5. Create a transfer of the Snapshot-type that will use the new 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 workload over to the target cluster.

9. To minimize resource consumption, delete the resources you no longer need:

   1. Delete the completed transfer.
   2. Delete the source and target endpoints.

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