I’ve been using Render for both personal and client hosting for a while and, to date, have spun up a new Postgres instance for each Django app. This is working perfectly (as you’d expect) but can prove costly, particularly for clients with small sites with low traffic. I’m thinking of changing my structure to host multiple (3 or 4) small clients on one instance but have a couple of questions:
- Has anyone successfully achieved this, were there any performance issues?
- I understand a Render db backup .sql includes all db information from the instance, is it possible to strip individual db out of the file so that I can easily take a backup and move a db from a shared instance to a dedicate instance if the site grows and needs more capacity?
- Are there any security concerns running multiple dbs for different clients on one Postgres instance?
Grateful for any advice.