I want to create a free tier clone of a production
PostgreSQL. As per my understanding, following are different ways
- create a snapshot of the production DB and restore it on
- create a read replica of the production DB using
t2.microand then detach it as independent database
- create a free tier database and restore a database dump of the production db
Option 3 is my last preference.
The problem is while creating read replica or restoring from snapshot, AWS doesn't explicitly allow to choose the free tier template. I just want to know if restoring to
t2.micro without any advanced features like autoscaling, performance monitoring etc. is equivalent to free tier or not? I read here that the key thing with AWS production DB is that AWS provisions a secondary database provisioned to fallback in event of failure of the primary database or the Availability Zone in which the database is running.