CODEWITHSUNDEEP
amazon-web-servicesgoogle-cloud-platformamazon-rdsgoogle-cloud-sqlpsql
user11020868
user11020868

Reputation: 427

Sync from Google Cloud Postgres DB to Amazon Aurora RDS

I want to periodically sync my Cloud SQL Postgres DB with an Amazon Aurora DB.

Setting up a Lambda that does pgdump and psql from one to the other should work but is there a cleaner solution?

Upvotes: 0

Views: 1050

Answers (2)

user11020868
user11020868

Reputation: 427

I ended up running a pg_dump and psql cron job on an EC2 instance. I could not access GCP db as endpoint as from DMS for some reason.

Upvotes: 1

Maurice
Maurice

Reputation: 13127

You can take a look at the Database Migration Service in AWS. As long as one of the databases is in AWS (which Aurora is) you can use it to perform full-loads + continuous migration using Change Data Capture. PostgreSQL is supported, so you'd have to create a migration instance, configure the Postgres and Aurora endpoints and set up a replication task.

Reference

Upvotes: 1

Related Questions