Multiple clusters on one box for PITR
От | Leigh Dyer |
---|---|
Тема | Multiple clusters on one box for PITR |
Дата | |
Msg-id | 475F2D9B.6060606@eclinic.com.au обсуждение исходный текст |
Ответы |
Re: Multiple clusters on one box for PITR
|
Список | 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
В списке pgsql-general по дате отправления: