pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: real time replication of pgsql database
Date: Sat, 25 Jun 2005 11:44:37 -0400
Message-ID: <m38y0ysaoq.fsf@knuth.cbbrowne.com> (raw)
References: <20050625065107.65076.qmail@web8607.mail.in.yahoo.com>

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?



view thread (5+ messages)  latest in thread

Message-ID: <m38y0ysaoq.fsf@knuth.cbbrowne.com>
Permalink:  ../m38y0ysaoq.fsf@knuth.cbbrowne.com/
Also on:    postgresql.org/message-id/m38y0ysaoq.fsf@knuth.cbbrowne.com

 · 

reply

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: cbbrowne@acm.org
  Subject: Re: real time replication of pgsql database
  In-Reply-To: <m38y0ysaoq.fsf@knuth.cbbrowne.com>
  References: <20050625065107.65076.qmail@web8607.mail.in.yahoo.com> <m38y0ysaoq.fsf@knuth.cbbrowne.com>

* 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