Heroku just does this. At my old job we would scale the database using replication multiple times a week depending on expected traffic.

https://devcenter.heroku.com/articles/heroku-postgres-follow...