1

I've a webapp hosted on AWS. This has Electric Beanstalk, with EC2 and then a RDS Postgres database at the bottom.

There's prod, UAT and staging environments and databases.

I want to take a recent snapshot of the prod database (well I've done that) and restore it on the staging database, as the current staging environment is a bit out of data wise.

Yet when I go to restore snapshots in the staging database, I can only restore those which were taken on the staging database.

Is there any way to restore the prod snapshot which I've made to the staging database?

Improve this question

1 Answer 1

Reset to default
1

Restoring a snapshot simply creates a new RDS instance. So if you restore the prod DB snapshot to staging then you will be creating a new RDS instance with the restored data in it.

Ps: Another option can be, using mysqldump to take backup from prod and then restoring it to the staging instance

Improve this answer
3
  • They're both in the same account. I certainly don't want to touch the live prod DB also. I think I just want staging now to point at the new RDS instance. I'm just having trouble finding where the EC2 instance says what database backs it.
    – Clinton
    Commented Jul 9, 2021 at 0:11
  • Hi, did you manage to solve this? You can try checking your app configuration for the connection strings with your rds endpoint name mentioned in it.
    – Kunal
    Commented Jul 20, 2021 at 15:05
  • Hi, did this solve your problem . If yes, would you please accept the answer
    – Kunal
    Commented Mar 25, 2022 at 13:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.