Striim Migration Service for Google Cloud Documentation

PostgreSQL to Google Cloud PostgreSQL Migration Guide

For an overview and conceptual discussion of SMSGC, see Striim Migration Service User Guide.

This document provides detailed instructions for migrating data from one of the following PostgreSQL sources to one of the following PostgreSQL targets using SMSGC.

Sources

SMSGC supports PostreSQL sources 9.4.x and later.

  • PostgreSQL on-premise

  • Amazon RDS for Aurora version 2.2.0 or later

  • Amazon RDS for PostgreSQL

Azure Database for PostgreSQL is not supported since logical replication, which is required for SMSGC to read change data, is currently in public preview rather than fully supported by Microsoft.

Targets

  • Google Cloud SQL for PostgreSQL

  • PostgreSQL 9.4.x or later running in a Google Compute Engine virtual machine

This document assumes the following:

  • You have completed the tasks described in Deploy SMSGC and Connect SMSGC with your private network.

  • You have the access and privileges required to install plugins and create a role in the source PostgreSQL server.

  • You have the privileges required to create a user on the target Google Cloud SQL for PostgreSQL instance.

To create the SMSGC application, you will perform the following tasks, as detailed in this document. It is important that you perform the steps in the order in which they are described here.

  1. If not already installed on the source PostgreSQL instance, install the wal2json plugin.

  2. In the source PostgreSQL instance, configure the wal2json plugin and create a role for SMSGC.

  3. In the target PostgreSQL instance, create a role for SMSGC.

  4. Copy the tables and data from the source to the target using the native tools of PostgreSQL and Google Cloud SQL for PostgreSQL. Alternatively, create tables in the target and create an initial load application to populate them as discussed in Create and test the initial load application.

  5. Create a streaming integration application by exporting TQL code for the initial load application, making a few revisions, and importing it.

  6. Test the streaming integration application and troubleshoot any problems encountered.

  7. Start the streaming integration application.

We strongly recommend you read both the Striim Migration Service User Guide and this entire document before starting to follow any of the detailed instructions below.