Quick-start migrations for homogeneous PostgreSQL

This page describes quick-start migrations for homogeneous PostgreSQL migrations to Cloud SQL for PostgreSQL and AlloyDB for PostgreSQL:

Guides and supported scenarios contains links to step-by-step instructions for all quick-start migration flows.
Overview provides the high-level description of what quick-start migrations are and how you can use them to enhance your migration experience.
Network connectivity explains the unique architecture employed by Database Migration Service in quick-start migrations.
Limitations describe known limitations and caveats to keep in mind when you follow quick-start migrations.

Guides and supported scenarios

Quick-start migrations for homogeneous PostgreSQL facilitate continuous homogeneous migrations to new or existing Cloud SQL for PostgreSQL or AlloyDB for PostgreSQL destinations. This migration flow is best suited for migrating from sources that have a private IP address in your Google Cloud Virtual Private Cloud (VPC) network, such as self-managed databases on Compute Engine, or Cloud SQL for PostgreSQL instances enabled for private networking. Sources hosted outside Google Cloud might need additional network components (such as a Cloud VPN connection) so that they can be reached at a private IP address within your VPC network.

You can begin your quick-start migration journey in multiple places in the Google Cloud console:

The Google Cloud console for Cloud SQL for PostgreSQL and AlloyDB for PostgreSQL, where you begin the quick-start migration directly from your instance or cluster. For more information, see:
- Run a quick-start migration directly from your Cloud SQL for PostgreSQL instance or cluster
- Run a quick-start migration directly from your AlloyDB for PostgreSQL cluster
Database Migration Service, where you can create a new destination cluster or instance as you configure the quick-start migration. For more information, see:
- Use quick-start migrations in Database Migration Service for Cloud SQL for PostgreSQL
- Use quick-start migrations in Database Migration Service for AlloyDB for PostgreSQL

Overview

Quick-start migrations are a lightweight continuous migration flow for homogeneous PostgreSQL scenarios. With quick-start migrations, Database Migration Service can automatically set up everything you need to migrate sources that have a private IP assigned in a VPC network, such as self-managed databases on Compute Engine or Cloud SQL for PostgreSQL instances.

At a high level, Database Migration Service simplifies the following tasks with quick-start migrations:

Database Migration Service creates the private connectivity configuration, the network attachment and its subnet required for Private Service Connect interfaces.
Database Migration Service creates the destination instance and configure the necessary private connectivity. You can also decide to use an existing destination instance to move only specific PostgreSQL databases into that instance.

After you set up the quick-start migration, you can monitor data movement progress with Database Migration Service observability features.

Network connectivity

At a high-level, quick-start migrations use a different networking architecture from standard homogeneous migrations. Database Migration Service and the destination Cloud SQL for PostgreSQL or AlloyDB for PostgreSQL instances are service producers that reside in their own dedicated networks (known as service networks), outside the VPC networks that you use in your Google Cloud project.

**Figure 1.** Simplified view of networking for quick-start migrations (click to enlarge)

Database Migration Service fully facilitates both source and destination connectivity for quick-start migrations.

For source database connectivity, quick-start migrations use Private Service Connect interfaces. This connectivity method requires that your source instance has a private IP address in your Google Cloud VPC network. Self-managed databases on Compute Engine or Cloud SQL for PostgreSQL instances can usually can meet this requirement out of the box. Sources hosted outside Google Cloud might need additional network components (such as a Cloud VPN connection) so that they can be reached at a private IP address within your VPC network.

For destination database connectivity, Database Migration Service fully manages the network communication to Cloud SQL for PostgreSQL instances or AlloyDB for PostgreSQL clusters. The only requirement is that your destination is enabled for Private Service Connect, but no further configuration is needed.

Source connectivity to self-hosted databases on Compute Engine

When you migrate from a self-hosted databases on Compute Engine, Database Migration Service creates the network attachment in the same VPC network where you have your VM.

This diagram shows network connectivity facilitated by Database Migration Service
for quick-start migrations from self-hosted databases on Compute Engine. — **Figure 2.** Network connectivity facilitated by Database Migration Service for quick-start migrations from self-hosted databases on Compute Engine. (click to enlarge)

Source connectivity to Cloud SQL for PostgreSQL

When you migrate from a Cloud SQL for PostgreSQL instance, Database Migration Service creates the network attachment in the VPC network where your instance has a private IP assigned. This IP can be a result of a Private Services Access (PSA) or Private Service Connect configuration. For more information, see Private IP configuration in the Cloud SQL documentation.

This diagram shows network connectivity facilitated by Database Migration Service
for quick-start migrations from a Cloud SQL for PostgreSQL instance. — **Figure 3.** Network connectivity facilitated by Database Migration Service for quick-start migrations from a Cloud SQL for PostgreSQL instance. (click to enlarge)

Source connectivity to databases outside Google Cloud

When you migrate from a database hosted outside Google Cloud, you need additional network components to ensure that your database has a private IP address assigned in your Google Cloud VPC network (for example a VPC network). Database Migration Service creates the network attachment in the VPC network where your instance has a private IP assigned.

This diagram shows network connectivity facilitated by Database Migration Service
for quick-start migrations from databases hosted on-premise or
as managed offerings outside Google Cloud. — **Figure 4.** Network connectivity facilitated by Database Migration Service for quick-start migrations from databases hosted on-premise or as managed offerings outside Google Cloud. (click to enlarge)

Limitations

The following limitations apply to quick-start migrations. If your migration scenario requires the use of any unsupported features, we recommend you follow the standard migration flow instead. For more information, see Migrate to Cloud SQL for PostgreSQL or Migrate to AlloyDB for PostgreSQL documentation pages.

Quick-start migrations don't support migrating from PostgreSQL versions 9.6 or lower.
Empty databases (that is, databases that only have system schemas) aren't supported.
Identity and Access Management (IAM) authentication for destination instances or clusters isn't supported. When you use quick-start migrations for a new destination, Database Migration Service connects as the default postgresql user. If you migrate to an existing destination, Database Migration Service creates a dedicated cloudsqlsuperuser or alloydbsuperuser account and uses it to connect to the destination. For more information about IAM, see IAM authentication in the Cloud SQL documentation or Manage IAM authentication in the AlloyDB for PostgreSQL documentation.
The only supported method for source database connectivity is Private Service Connect interfaces. Your source database needs to have a private IP assigned in the VPC network. Other homogeneous source connectivity methods (such as public IP allowlists, reverse SSH tunnels, or VPC network peering) aren't supported for quick-start migrations.
Only Private Service Connect-enabled destinations are supported. PSA Cloud SQL for PostgreSQL or AlloyDB for PostgreSQL instances aren't supported as migration destinations.
SSL encryption options for source connections only support none and required variants for quick-start migrations.
Homogeneous MySQL or SQL Server migrations aren't supported for quick-start migrations.
Advanced features, such as customized data dump parallelism settings aren't supported.
Only continuous migrations are supported.
Quick-start migrations can accommodate up to 50 databases per migration job. You don't have to migrate all databases in your source database server. Database Migration Service lets you select which databases you want to migrate.
For consistent replication, Database Migration Service requires that all source tables have primary keys. If your tables don't have primary keys, then only INSERT operations are replicated during the Change Data Capture (CDC) phase. If you want to also replicate UPDATE and DELETE operations for tables without primary keys, you need to modify those tables with the REPLICA option. Exact steps are covered in the quick-start migration guides.
Standard migration fidelity limitations apply. For more information, see Migration fidelity in AlloyDB for PostgreSQL migrations, Migration fidelity in Cloud SQL for PostgreSQL migrations.