You should also look at http://pgfoundry.org/projects/pgcluster/ On Sat, Jun 25, 2005 at 11:44:37AM -0400, Christopher Browne wrote: > Centuries ago, Nostradamus foresaw when hellz_waren@xxxxxxxxxxx (hellz waren) would write: > > we are designing a heavy duty database in pgsql that > > expects to grow at an average of 100 MB spread over > > tables of 250 tables. > > > > We require always on database (24 X 7) database. And > > if one fails, the other one needs to start up. > > > > Could you someone tell me if there's any open source > > project that enables real time replication of data > > back up. > > I can use heartbeat, mon etc then to awake the other > > server if the main server is down. > > You might want to look into Slony-I; it can do this sort of thing. > > Version 1.1.0 was released on Thursday... > -- > wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com'). > http://slony.info > Who's afraid of ARPA? > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx > -- Jim C. Nasby, Database Consultant decibel@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
