From: Jim C. Nasby <decibel@decibel.org>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: real time replication of pgsql database
Date: Sun, 26 Jun 2005 12:30:43 -0500
Message-ID: <20050626173043.GY89438@decibel.org> (raw)
In-Reply-To: <m38y0ysaoq.fsf@knuth.cbbrowne.com>
References: <20050625065107.65076.qmail@web8607.mail.in.yahoo.com>
<m38y0ysaoq.fsf@knuth.cbbrowne.com>
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?"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: decibel@decibel.org, cbbrowne@acm.org
Subject: Re: real time replication of pgsql database
In-Reply-To: <20050626173043.GY89438@decibel.org>
References: <20050625065107.65076.qmail@web8607.mail.in.yahoo.com> <m38y0ysaoq.fsf@knuth.cbbrowne.com> <20050626173043.GY89438@decibel.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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