pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedreal time replication of pgsql database
5+ messages / 4 participants
[nested] [flat]
* real time replication of pgsql database
@ 2005-06-25 06:51 hellz waren <hellz_waren@yahoo.co.in>
0 siblings, 2 replies; 5+ messages in thread
From: hellz waren @ 2005-06-25 06:51 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: real time replication of pgsql database
@ 2005-06-25 15:17 Jeff Frost <jeff@frostconsultingllc.com>
parent: hellz waren <hellz_waren@yahoo.co.in>
1 sibling, 1 reply; 5+ messages in thread
From: Jeff Frost @ 2005-06-25 15:17 UTC (permalink / raw)
To: hellz waren <hellz_waren@yahoo.co.in>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: real time replication of pgsql database
@ 2005-06-25 15:44 Christopher Browne <cbbrowne@acm.org>
parent: hellz waren <hellz_waren@yahoo.co.in>
1 sibling, 1 reply; 5+ messages in thread
From: Christopher Browne @ 2005-06-25 15:44 UTC (permalink / raw)
To: pgsql-admin
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?
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: real time replication of pgsql database
@ 2005-06-26 17:30 Jim C. Nasby <decibel@decibel.org>
parent: Christopher Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 5+ messages in thread
From: Jim C. Nasby @ 2005-06-26 17:30 UTC (permalink / raw)
To: Christopher Browne <cbbrowne@acm.org>; +Cc: pgsql-admin
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?"
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: real time replication of pgsql database
@ 2005-06-27 13:30 hellz waren <hellz_waren@yahoo.co.in>
parent: Jeff Frost <jeff@frostconsultingllc.com>
0 siblings, 0 replies; 5+ messages in thread
From: hellz waren @ 2005-06-27 13:30 UTC (permalink / raw)
To: Jeff Frost <jeff@frostconsultingllc.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-06-27 13:30 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-25 06:51 real time replication of pgsql database hellz waren <hellz_waren@yahoo.co.in>
2005-06-25 15:17 ` Jeff Frost <jeff@frostconsultingllc.com>
2005-06-27 13:30 ` hellz waren <hellz_waren@yahoo.co.in>
2005-06-25 15:44 ` Christopher Browne <cbbrowne@acm.org>
2005-06-26 17:30 ` Jim C. Nasby <decibel@decibel.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox