offsite warm backup suggestions?

From: "John Sequeira" <john_seq(at)hotmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: offsite warm backup suggestions?
Date: 2002-10-31 20:52:03
Message-ID: F27Mn5f5bSwQpoeDhtN00021f25@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a question about configuring a warm spare.

I'm on a project that's looking to deploy a fairly transaction-intensive
application (250K inserts/day) running on a linux/apache/mod_perl/postgres
setup and would like to implement an offsite warm spare (as warm as
possible). The warm spare would be for disaster recovery as opposed to
failover. In the SQL Server/Oracle worlds I'm more familiar with I believe
I'm looking for something like log shipping.

Does anyone have successful experience using rsync/usogres or one of the pg
replication projects to accomplish this?

Commercial solutions are acceptable, though OSS solutions are preferred.

Thanks,

John

_________________________________________________________________
Unlimited Internet access for only $21.95/month. Try MSN!
http://resourcecenter.msn.com/access/plans/2monthsfree.asp

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-10-31 21:19:03 Re: offsite warm backup suggestions?
Previous Message Josh Goldberg 2002-10-31 19:13:34 Re: To Blob or Not to Blob? THAT is the question.