* 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.
In response to
pgsql-admin by date
|Next:||From: Gl Vm||Date: 2012-10-05 16:19:00|
|Subject: Promoting a Cascading Standby|
|Previous:||From: Stephen Frost||Date: 2012-10-04 01:18:03|
|Subject: Re: Migrating to PG 9.2 (LONG, SORRY)|