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...
Who's afraid of ARPA?
In response to
pgsql-admin by date
|Next:||From: Alberto||Date: 2005-06-25 15:55:30|
|Subject: pg_dump -Fc does not dump indexes]|
|Previous:||From: Jeff Frost||Date: 2005-06-25 15:17:48|
|Subject: Re: real time replication of pgsql database|