Re: [GENERAL] Postgres WarmStandby using ZFS or Snapshot to create Web DB?

2007-12-02 Thread Robert Treat
On Thursday 29 November 2007 16:08, Jennifer Spencer wrote: I am looking for suggestions in setting up a large postgres database scenario. We are running a science project with a lot of data expected from the science instrument. If you have time to comment, any advice is most welcome! Here's

[GENERAL] Postgres WarmStandby using ZFS or Snapshot to create Web DB?

2007-11-29 Thread Jennifer Spencer
I am looking for suggestions in setting up a large postgres database scenario. We are running a science project with a lot of data expected from the science instrument. If you have time to comment, any advice is most welcome! Here's the deal: 1. We expect to store ~1TB per year of data for 10

Re: [GENERAL] Postgres WarmStandby using ZFS or Snapshot to create Web DB?

2007-11-29 Thread Greg Smith
On Thu, 29 Nov 2007, Jennifer Spencer wrote: 4. We need to have a Warm Standby available in case of disaster. We plan to use PITR with WAL files for this (again, unless there is a compelling reason not to). ... Another plan involves using a Solaris 10 ZFS solution to clone the warm standby