PostgreSQL RDS Creation/Migration in AWS

Too Long; Didn't Read

This article describes about process to create a database from an existing one in AWS, we will cover the steps to migrate your schema and data from an existing database to the new one. You might encounter this process when there is a need for creating a RDS instance for different environments (System Testing, Integration Testing or Performance Testing) in your infrastructure or during database migration from one version to another. Since most of the organizations are moving into You Build You Own model relying on DBA team for each change request will not be required if we know few simple steps to manage database changes on our own. I am just writing this article as it might save some time on getting things done faster for what is needed to spin up your RDS instance with necessary schema and data in it.