A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://cloud.google.com/database-migration/docs/postgres/create-source-connection-profile below:

Create a source connection profile | Database Migration Service

Skip to main content Create a source connection profile

Stay organized with collections Save and categorize content based on your preferences.

You can create a connection profile on its own or in the context of creating a specific migration job. Either way, all connection profiles are available for review and modification on the Connection profiles page, and can be reused across migration jobs.

Creating a source connection profile on its own is useful if the person who has the source access information is not the same person who creates the migration job. You can also reuse a source connection profile definition in multiple migration jobs. If you use the same profile for multiple migrations, you need to update the max_replication_slots parameter in the source database to account for the number of replicas you're creating.

To see which source databases Database Migration Service supports, see Supported source and destination databases.

To create a source connection profile, follow these steps:

  1. Go to the Connection profiles page in the Google Cloud Console.
  2. Click Create profile.
  3. On the Create a connection profile page, provide the following information required to connect to your source:
    1. From the Profile role list, select Source.
    2. From the Database engine list, select your source database engine.

      If you select Cloud SQL for PostgreSQL from this list, then a Cloud SQL instance list appears. Select the Cloud SQL instance that you want to migrate.
    3. Enter a Connection profile name. This is used in the connection profile list as well as when an existing connection profile is selected in the creation of a migration job.
    4. Keep the auto-generated Connection profile ID.
    5. Enter a Hostname or IP address.

      If the source database is hosted in Google Cloud or if a reverse SSH tunnel is used to connect the destination database to the source database, then specify the private (internal) IP address for the source database. This address will be accessible by the Cloud SQL destination. For more information, see Configure connectivity using VPC peering.

      For other connectivity methods, such as IP allowlist, provide the public IP address.

    6. Enter the Port that's used to access the host. The default PostgreSQL port is 5432.
  4. Enter a username and password for the source database. The user must have these privileges.
  5. In the Connection profile region section of the page, select the region where you want to save the connection profile.

    Connection profiles, like all resources, are saved in a region. Region selection doesn't impact which migration jobs can use them, or which regions can connect to the data location itself, but can impact availability in the case of regional downtime.
  6. Optional: If the connection is made over a public network (by using IP allowlists), then we recommend that you use SSL/TLS encryption for the connection between the source and destination databases.

    In the Secure your connection section, from the Encryption type list, you can select one of the following SSL/TLS configuration options:

  7. For more information about creating certificates and keys for your source database server, see Secure TCP/IP Connections with SSL.

    If you're having trouble uploading the key, then select the Enter manually option, and copy and paste the key into the text area.

  8. Click Create at the bottom of the page.

    The Connection profiles page appears, and the newly created connection profile is displayed.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-07-09 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-09 UTC."],[[["Connection profiles can be created independently or during the setup of a migration job, and are reusable across multiple jobs, allowing for efficient management of database connections."],["When creating a source connection profile, you must specify details such as the profile role, database engine, connection name, ID, hostname or IP address, and the port, as well as the source database's username and password."],["The choice of connection profile region does not affect which migration jobs can utilize the profile or the regions that can access the data but can impact the availability of the profile."],["Secure connections via SSL/TLS are recommended for public network connections and offer options including no encryption, basic encryption, TLS authentication, and mTLS authentication for enhanced security."],["Depending on the security level required, the setup may require the x509 PEM-encoded certificate of the Certificate Authority (CA), the client certificate, and the associated client key for secure source and destination authentications."]]],[]]


RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4