• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Working with RDS for PostgreSQL
  5. Migrating PostgreSQL Data Using psql
  6. Preparing for Data Migration

Preparing for Data Migration

PostgreSQL supports logical backups. You can use the pg_dump logical backup function to export backup files and then import them to RDS using psql.

You can access RDS through an EIP or ECS.

Preparations

  1. Prepare an ECS for accessing DB instances in the same VPC subnet or prepare a device for accessing RDS through a public network.
    • To connect to a DB instance through an ECS, you must first create an ECS.

      For details about how to create and connect to an ECS, see section How Can I Create and Connect to an ECS?

    • To connect to a DB instance through an EIP, you must:
      1. Bind the EIP to the DB instance. For details, see Binding an EIP.
      2. Ensure that the local device can access the EIP that has been bound to the DB instance.
  2. Install the PostgreSQL client psql on the ECS or device that was prepared in 1. Prepare an ECS or a d....

    For details, see section How Can I Install the PostgreSQL Client?

    NOTE:

    The PostgreSQL client version must be the same as the version of RDS for PostgreSQL. The PostgreSQL database or client will provide pg_dump and psql.