Multiple Database Strategy

From: Howard Cole <howardnews(at)selestial(dot)com>
To: 'PgSql General' <pgsql-general(at)postgresql(dot)org>
Subject: Multiple Database Strategy
Date: 2008-04-24 19:10:54
Message-ID: 4810DB3E.6060604@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I run several databases on a windows server all using the same cluster.
Each database is backed up separately using pg_dump - but the size of
the databases is leading me to think that the WAL backup strategy will
reduce my backup bandwidth. The flaw in this is that the WAL backup is
not confined to a single database but the entire cluster so that I have
to restore all the database in the cluster to a point in time, rather
than just a single database.

One method where I can still use the WAL backup is to put each database
into its own cluster. So I can restore each database individually.

Anyway, this leads me to the question: Has anyone tried splitting
multiple database (10+) into clusters and what are the memory and
processor overheads in comparrison to more connections in a single cluster?

Thanks.
Howard.
www.selestial.com

Browse pgsql-general by date

  From Date Subject
Next Message Matthew T. O'Connor 2008-04-24 20:15:30 Re: How to modify ENUM datatypes?
Previous Message Tino Wildenhain 2008-04-24 19:01:14 Re: How to modify ENUM datatypes?