Migrate Google Cloud SQL for PostgreSQL to Amazon RDS and Amazon Aurora using pglogical
Database Blog
This article provides a comprehensive guide to migrating a PostgreSQL database from Google Cloud SQL to Amazon RDS and Amazon Aurora using the pglogical extension. Key steps include:
- Configuring the primary Google Cloud SQL database with necessary permissions and parameters
- Setting up the Amazon RDS or Aurora PostgreSQL target database
- Creating replication users and enabling logical replication
- Creating pglogical nodes and subscriptions for data migration
The article also highlights important limitations of pglogical, such as:
- No automatic replication of sequences, primary key changes, extensions, or DDLs
- Limited support for materialized views and large objects
Workarounds are provided for most limitations, making pglogical a viable option for PostgreSQL database migrations between cloud platforms.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
2026
2026
2026
2024
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.