Leigh Dyer wrote:
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?
There's no problem running multiple copies of PG on the same box - lots of the developers do it, and I do on my laptop here. Different data-dir and port and you're away.
Efficiency can be an issue though - you'll have two sets of WAL files being written to, and two separate sections of shared memory to balance. If you're not pushing the hardware though, it should be straightforward enough.
-- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
