Обсуждение: offsite warm backup suggestions?
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
On Thu, Oct 31, 2002 at 03:52:03PM -0500, John Sequeira wrote: > Does anyone have successful experience using rsync/usogres or one of the pg > replication projects to accomplish this? Yes. We use the rserv (eRServer) software from PostgreSQL, Inc. It works for us. You can't use rsync for this. It will destroy data. The rserv in contrib/ may not keep up with your volume. I haven't tried dbmirror. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M2P 2A8 +1 416 646 3304 x110
On Thu, 2002-10-31 at 14:19, Andrew Sullivan wrote: > On Thu, Oct 31, 2002 at 03:52:03PM -0500, John Sequeira wrote: > > Does anyone have successful experience using rsync/usogres or one of the pg > > replication projects to accomplish this? Usogres just flat didn't work well for us, and it introduces another program that could cause the system to fail. > > Yes. We use the rserv (eRServer) software from PostgreSQL, Inc. It > works for us. We use rserv here at work as well. > You can't use rsync for this. It will destroy data. > > The rserv in contrib/ may not keep up with your volume. I'm going to be posting some commentary to doing replication with rserv to the list soon. We recently set up 2 database servers to do replication with it, and I must say after our initial little hiccups we have had nothing but good luck with it. I heartily recommend even the rserv in contrib, if you don't have/want to shell out the dollars for the commercial version. If you have any problems, post up your question and it very likely can be answered. We actually haven't found any slowdown caused by it, and 250k inserts per day, depending on how the inserts are spread out really aren't that many. Sincerely, Will LaShell > > I haven't tried dbmirror. > > A
Вложения
Does eRserver work with pgsql 7.2.3 or 7.3b3 ? regds mallah. > On Thu, Oct 31, 2002 at 03:52:03PM -0500, John Sequeira wrote: >> Does anyone have successful experience using rsync/usogres or one of the pg replication >> projects to accomplish this? > > Yes. We use the rserv (eRServer) software from PostgreSQL, Inc. It works for us. > > You can't use rsync for this. It will destroy data. > > The rserv in contrib/ may not keep up with your volume. > > I haven't tried dbmirror. > > A > > -- > ---- > Andrew Sullivan 204-4141 Yonge Street > Liberty RMS Toronto, Ontario Canada > <andrew@libertyrms.info> M2P 2A8 > +1 416 646 3304 x110 > > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off > all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/
> > > Does eRserver work with pgsql 7.2.3 or 7.3b3 ? It does work with 7.2.3, if you use the commercial version. It is definitely broken right now in 7.3, but it will certainly be upgraded to work with 7.3 some time before we upgrade to 7.3.x. (Of course, when that will happen is unclear to me right now.) To find out the timetable to make eRServer work with 7.3, you should contact PostgreSQL, Inc. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada <andrew@libertyrms.info> M2P 2A8 +1 416 646 3304 x110