Re: [GENERAL] Multiple Schemas vs. Multiple Databases

On 10/13/2017 12:47 PM, John R Pierce wrote:

On 10/13/2017 12:29 PM, Igal @ Lucee.org wrote:

The main things that I need to do is:

  a) Be able to backup/restore each "part" separately.  Looks like pg_dump allows that for schemas via the --schema=schema argument.

  b) Be able to query aggregates from the secondary "part" and store the results in the primary one, which also seems easier with multiple schemas than multiple databases.

Am I right to think that two schemas are better in this use case or am I missing something important?

generally, yeah, unless you eventually decide to split off the two databases onto separate servers for performance reasons.   Of course, to access the 'other' database, you'd need to use postgres_fdw or dblink.

Thank you both for confirming,

Igal Sapir
Lucee Core Developer
Lucee.org