Alvaro Herrera wrote:
> Heikki Linnakangas escribió:
>> For more usefulness, we'd need to keep databases more separate from each
>> other than we do now. Databases would need to have their own transaction
>> counters, for example.
>
> Hmm, why? Perhaps you are right but I don't see the reason.
If each database was stand-alone, you would need only one base backup
and WAL per database to restore, instead of base backup and WAL of the
database, and base backup and WAL of shared stuff. You could backup one
database in cluster, restore it somewhere else, and later copy it back
to the original cluster. You could back up one database at a time, and
restore the whole cluster from the N per-database backups.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com