|From:||Simon Riggs <simon(at)2ndQuadrant(dot)com>|
|To:||Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>|
|Subject:||Re: replication solution|
|Views:||Raw Message | Whole Thread | Download mbox|
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
|Next Message||Kasia Tuszynska||2010-10-13 20:21:15||Re: two questions about pg 9.0|
|Previous Message||Lennin Caro||2010-10-13 19:17:06||Re: Cannot connect to database|