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?