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 <http://lucee.org/>
