Linkedin

  • Home >
  • Transport PostgreSQL databases between two Amazon RDS DB instances using pg_transport

Transport PostgreSQL databases between two Amazon RDS DB instances using pg_transport

Project Overview

Project Detail

This pattern describes the steps for migrating extremely large databases between two Amazon Relational Database Service (Amazon RDS) for PostgreSQL DB instances by using the pg_transport extension. This extension provides a physical transport mechanism to move each database. By streaming the database files with minimal processing, it provides an extremely fast method for migrating large databases between DB instances with minimal downtime. This extension uses a pull model where the target DB instance imports the database from the source DB instance

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/transport-postgresql-databases-between-two-amazon-rds-db-instances-using-pg_transport.html?did=pg_card&trk=pg_card

To know more about this project connect with us

Transport PostgreSQL databases between two Amazon RDS DB instances using pg_transport