2 repository databases

[jdbruijn]

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.

[Harjo]

that does'nt make a difference,

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

[jdbruijn]

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?

[Harjo]

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

[jdbruijn]

Ok, thx Harjo.