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

Re: real time replication of pgsql database

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: real time replication of pgsql database
Date: 2005-06-25 15:44:37
Message-ID: m38y0ysaoq.fsf@knuth.cbbrowne.com (view raw or flat)
Thread:
Lists: pgsql-admin
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?

In response to

Responses

pgsql-admin by date

Next:From: AlbertoDate: 2005-06-25 15:55:30
Subject: pg_dump -Fc does not dump indexes]
Previous:From: Jeff FrostDate: 2005-06-25 15:17:48
Subject: Re: real time replication of pgsql database

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