On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote:
> Hi all,
> we are looking for a solution to create a replicated database to be used
> as reporting database with same data of production ( we can accept a lag
> of some minutes).
> we already have the Point In Time Recovery but we need a solution where
> the standby is always open in readonly , but the data is replicated
> continuosly from primary.
> The Slony solution could be a possibility but the production database is
> 80 Gb of data with around 10000 transaction each hour.
> DO you have some suggestion for our implementaiont if exists??
PostgreSQL 9.0 is production ready now and supports Hot Standby, which
is exactly what you want.
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
In response to
pgsql-admin by date
|Next:||From: Kasia Tuszynska||Date: 2010-10-13 20:21:15|
|Subject: Re: two questions about pg 9.0|
|Previous:||From: Lennin Caro||Date: 2010-10-13 19:17:06|
|Subject: Re: Cannot connect to database|