CODEWITHSUNDEEP
google-cloud-sql
bjorndv
bjorndv

Reputation: 623

Can not restore backup to target instance - replicated setup, target instance non replicated setup

When trying to restore a backup to a new cloud sql instance I get the following message when using curl:

{
 "error": {
  "errors": [
   {
    "domain": "global",
    "reason": "invalidOperation",
    "message": "This operation isn\"t valid for this instance."
   }
  ],
  "code": 400,
  "message": "This operation isn\"t valid for this instance."
 }
}

When trying via google cloud console, after clicking 'ok' in the 'restore instance from backup' menu nothing happens.

Upvotes: 2

Views: 497

Answers (1)

user666406
user666406

Reputation: 181

I'll answer even thought this is a very old question, maybe useful for someone else (would have been for me).

I just had the same exact same error, my problem was that the storage capacity for the target instance was different than the one for the source instance. My source instance was accidentally deleted so this was a bit troublesome to figure out. This check list helped me https://cloud.google.com/sql/docs/postgres/backup-recovery/restore#tips-restore-different-instance

Upvotes: 3

Related Questions