2 repository databases

Classic Servoy
1

I’m currently installing a new servoy server environment. On this server there will be 2 servoy application servers, but i’m planning on using just 1 PostgreSQL server.
For the repository database I can use one of the following approaches:

  • 2 databases
  • 1 database with 2 schema’s

I would like to know what the pro-cons are for both approaches? I’m leaning to using 2 schema’s, but I’m curious if that is the safest way to do it.

2

that does’nt make a difference,

we use for separate servoy instances, on 1 DB instance: schema’s, than everything is nicely grouped.

3

And how does this relate to backup? Do you backup the entire database (all schema’s at once) or a separate backup for each schema?

4

that is totally up to you, both is possible.
we backup every db, separate

5

Ok, thx Harjo.