![]() We create a separate user with required system attributes and permissions to accomplish data replication task. The good news is that we can configure pglogical on GCP Cloud SQL database. In GCP Cloud SQL, the user postgres doesn’t have SUPERUSER and REPLICATION attributes, which is why any attempt to use the postgres user for the change data capture fails. If pglogical extension isn’t configured, then the database user that connects to source PostgreSQL database must have SUPERUSER attribute. One method of is a simple test_replica extension and the second one is pglogical extension. We use AWS Secrets Manager to store user and password information to connect to source and target databases.ĪWS DMS supports two methods of change data capture from PostgreSQL. ![]() AWS DMS encrypts the data at rest on replication instance by default. The traffic to Amazon RDS instance is encrypted as well. We create an AWS DMS Replication Instance in a private subnet with a replication instance that connects to GCP Cloud SQL database over secure Secure Sockets Layer (SSL) and Transport Layer Security (TLS) connections. We recommend you use a site-to-site virtual private network (VPN) connection between GCP and AWS. The following architecture diagram describes the components involved in the migration process. To learn more about migration best practices, read this post best practices for migrating PostgreSQL databases to Amazon RDS and Amazon Aurora. The goal is to migrate this database from GCP Cloud SQL to Amazon RDS, but the same approach can be used to migrate any on-premises PostgreSQL database. We used a realistic scenario with stored procedures, sequences, and different types of the tables (small tables and tables with millions of rows). The sample database data we used can be found on the following GitHub repo. In this post, we perform a sample database migration and describe step-by-step approach. AWS DMS allows minimal downtime migrations. Using AWS DMS you can do the initial load of the tables and automatically capture all changes and apply them to the destination database. To accomplish this task, we use AWS Database Migration Service (AWS DMS), a data migration and replication service. In this post, we walk you through a procedure to migrate the PostgreSQL database from Google Cloud Platform (GCP) Cloud SQL to Amazon Relational Database Service (Amazon RDS) for PostgreSQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |