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: (view raw, whole thread or download thread mbox)
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','').
Who's afraid of ARPA?

In response to


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-2017 The PostgreSQL Global Development Group