Should we add a separate Postgres instance for Ory components?

[yatharthranjan]

Is your feature request related to a problem? Please describe.
Currently, all the databases are created on a single Postgres instance with the same master credentials. This is not ideal for Ory components as these can contain identifiable data.

Describe the solution you'd like
Going forward, it would be nice to separate Hydra, Kratos and any other SEP databases to a separate Postgres instance. What do you think?

Describe alternatives you've considered
Use different postgres user accounts for various databases instead of using the master one.

Additional context
The caveat is more resources required and management overhead

[keyvaann]

This is a good idea. Once #258 is implemented we can easily create separate database instances for each application but at the moment, it's not so easy to implement.

[pvannierop]

In #354 the default is to use a single database cluster (with replicate pods) that contains different databases, each with a unique username/password combination. The idea here is to create a deployment with a low footprint, but still offering improved security through service-specific credentials. Documentation has been added on how to configure external databases for each of the services, when desired. @yatharthranjan would this be ok with you?