Change region in google sql cloud

Question

My current region for the Google SQL cloud is now in the USA. I want to change the region to Europe.

Deangelis

Answer 1

Once created, a Cloud SQL instance cannot be moved between regions. You can create a new instance, export the old one and import it into the new one.

Mikiso

Do you now of a good resource that help to walk through the process of export / import for postgresql? – Prawn

Answer 2

Now you can move Cloud SQL with replica feature.

1. Create a replica in a destination region
2. Promote the replica into primary one
3. Change application database configuration

Earwax

this is the solution. using replica then promote – Madalynmadam