Skip site navigation (1) Skip section navigation (2)

Re: real time replication of pgsql database

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: real time replication of pgsql database
Date: 2005-06-26 17:30:43
Message-ID: 20050626173043.GY89438@decibel.org (view raw or flat)
Thread:
Lists: 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(at)yahoo(dot)co(dot)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(at)postgresql(dot)org
> 

-- 
Jim C. Nasby, Database Consultant               decibel(at)decibel(dot)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?"

In response to

pgsql-admin by date

Next:From: Jeff FrostDate: 2005-06-26 18:52:00
Subject: Re: restoring wal archive and pg_xlog dir
Previous:From: AlbertoDate: 2005-06-26 03:46:21
Subject: Re: pg_dump -Fc does not dump indexes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group