Thread: real time replication of pgsql database
hi, 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. Thanks, Hrishikesh __________________________________________________________ How much free photo storage do you get? Store your friends 'n family snaps for FREE with Yahoo! Photos http://in.photos.yahoo.com
Sounds like slony is what you're looking for: http://slony.info/ On Sat, 25 Jun 2005, hellz waren wrote: > Could you someone tell me if there's any open source > project that enables real time replication of data > back up. -- Jeff Frost, Owner <jeff@frostconsultingllc.com> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954
Centuries ago, Nostradamus foresaw when hellz_waren@yahoo.co.in (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?
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@yahoo.co.in (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@postgresql.org > -- Jim C. Nasby, Database Consultant decibel@decibel.org 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?"
I think slony is the solution. thanks. i will install it and will see the result. Hellz_Waren --- Jeff Frost <jeff@frostconsultingllc.com> wrote: > Sounds like slony is what you're looking for: > > http://slony.info/ > > On Sat, 25 Jun 2005, hellz waren wrote: > > > Could you someone tell me if there's any open > source > > project that enables real time replication of data > > back up. > > -- > Jeff Frost, Owner <jeff@frostconsultingllc.com> > Frost Consulting, LLC > http://www.frostconsultingllc.com/ > Phone: 650-780-7908 FAX: 650-649-1954 > _______________________________________________________ Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for FREE! http://in.mail.yahoo.com