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
|
