Multiple clusters on one box for PITR

From: Leigh Dyer <leigh(at)eclinic(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple clusters on one box for PITR
Date: 2007-12-12 00:38:51
Message-ID: 475F2D9B.6060606@eclinic.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I run a PostgreSQL 8.1 server that hosts two main applications -- both
web-based OLTP-type work -- with a few databases for each. I'm currently
using pg_dump for backups, but the clients for one of the applications
we're hosting as asked to be moved to PITR because they like the idea of
being able to restore their databases to any point in time. The problem
is that while that client is only using about 1GB on the box, the other
is using about 25GB, and since PITR is cluster-wide, I'd be stuck
restoring 26GB worth of databases if I ever needed to go to the backups.

However, I'm running on the Debian Etch packages, which seem to make it
quite easy to run multiple clusters, enabling me to run PITR just on the
application that requires it. Would running separate clusters on the one
box for these two applications be a sensible thing to do? Are there
resource limits that I should be aware of? Any other issues?

Thanks
Leigh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-12-12 00:54:40 Re: how to create aggregate xml document in 8.3?
Previous Message Robert Treat 2007-12-12 00:38:21 Re: top posting