pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
real 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