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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
