* Babay Adi, Hava wrote:
> On the same regard – Some of the mentioned modules in the mentioned
> application use a set of tables which is logically separate (there are
> no join statements with tables of other modules). What are the pros\cons
> of using a separate database instead of a separate schema for
> maintaining such tables?
For one thing, with multiple databases you cannot easily take consistent
backups using pg_dump, because a transaction is local to a single database.
--
Christian