Re: replication solution

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: replication solution
Date: 2010-10-13 20:06:27
Message-ID: 1287000387.1709.2649.camel@ebony
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-admin

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
PostgreSQL Development, 24x7 Support, Training and Services

In response to


Browse pgsql-admin by date

  From Date Subject
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