Fastest way to reset an AWS RDS instance to an initial state?
<p>I'm experimenting with creating a staging version of a simple postgres RDS backed CRUD web app on elastic beanstalk. The aim of this staging version is to run integration tests against when implementing new code changes, before redeploying these changes to the production environment.</p>

<p>The current problem I have is reseting the staging stack. I want a blank DB instance at the start of my integration tests. Redeploying a new RDS instance however takes several minutes which means the integration tests take a long time (>20 minutes) to run.</p>

<p>Since it's on elastic beanstalk it's in a VPC and therefore to reset the DB with SQL commands it seems like the CI server would have to do some tricky stuff with ssh tunnels which doesn't (at least to me) that simple either.</p>

<p>Is there a fast way to reset a running RDS instance to a blank state for the purpose of testing? </p>