Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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


pgsql-admin by date

Next:From: Kasia TuszynskaDate: 2010-10-13 20:21:15
Subject: Re: two questions about pg 9.0
Previous:From: Lennin CaroDate: 2010-10-13 19:17:06
Subject: Re: Cannot connect to database

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group