Suspend a database
complete
j
jjbii
I’m getting ready to launch my first site hosted on Render, and during development I’ve maintained a staging web service and database, and a production web service and database. When the site is live, I’m planning to suspend the staging service so I won't be charged for an environment that I don't need. I would like to do the same for the staging database, but that's not currently possible on Render. My options are to either delete the database and possibly restore it later, or keep paying for the database indefinitely, even though it won't be used.
Log In
S
Shantanu Joshi
complete
To suspend a database use the Suspend Database button located below the access control section.
Suspended Databases can be resumed at any time using the Resume Database button.
j
jjbii
Shantanu Joshi: Thanks so much for implementing this!
Anurag Goel
in progress
Anurag Goel
planned
We should definitely allow this!
S
Sunny R. Juneja
I personally don't think this should be handled by Render. As far as I know, Heroku does this the same way. I don't see any user facing downsides to this feature but comparing it the backlog of other stuff, I would rather them work on other things. If they were going to address something likee this, I would rather that you can "fork the database" and it spins up a copy of the database in under 2 minutes.
Anurag Goel
Sunny R. Juneja: there are other valid use cases: for example, suspensions are much better than deletions when an account payment isn't received in time.